sample of spool & sqlldr

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

spool导出

#! /bin/ksh <a href="http://code.js-code.com/tag/sql/" target="_blank" class="keywords">sql</a>plus -S user/<a href="http://code.js-code.com/tag/passwor/" target="_blank" class="keywords">passwor</a>d >/dev/null<<!EOD set <a href="http://code.js-code.com/tag/heading/" target="_blank" class="keywords">heading</a> off set <a href="http://code.js-code.com/tag/Feed/" target="_blank" class="keywords">Feed</a><a href="http://code.js-code.com/tag/BAC/" target="_blank" class="keywords">BAC</a>k off set echo off set pagesize 0 set li<a href="http://code.js-code.com/tag/nes/" target="_blank" class="keywords">nes</a>ize 200 spool ipad_imei.txt <a href="http://code.js-code.com/tag/SELE/" target="_blank" class="keywords">SELE</a>ct range_start || '|' || range_end || '|' || app_name || '|' || ret_val || '|' || <a href="http://code.js-code.com/tag/REMARK/" target="_blank" class="keywords">REMARK</a> 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,<a href="http://code.js-code.com/tag/REMARK/" target="_blank" class="keywords">REMARK</a> )

sqlldr执行

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