sample of spool & sqlldr

平时工作中，spool和sqlldr用得少，显得有点生疏，上次没保存使用过程，这次找不到样本，囧！好不容易才搞出来，马上记下来吧。

 

spool导出

 

#! /bin/ksh sqlplus -S user/password >/dev/null<<!EOD set heading off set feedback off set echo off set pagesize 0 set linesize 200 spool ipad_imei.txt select range_start || '|' || range_end || '|' || app_name || '|' || ret_val || '|' || remark from smt_lt_app_range where app_name='IPAD_IMEI'; spool off exit !EOD

 

sqlldr导入，ctl文件

 

LOAD DATA INFILE * APPEND INTO TABLE smt_lt_app_range FIELDS TERMINATED BY '|' ( RANGE_START, RANGE_END, APP_NAME, RET_VAL, REMARK )

 

sqlldr执行

 

sqlldr user/password data=ipad_imei.txt control=ipad_imei.ctl