createCSV.bat
============================================================
sqlplus test01/test01@172.16.XXX.XXX:1521/ORAHON @csv.SQL
============================================================
csv.SQL
============================================================
set echo off
set linesize 1000
set pagesize 0
set trimspool on
spool temp.csv
select USER_ID||','||JIGYOUCD from pjkihon;
spool off
exit
============================================================
readCSV.bat
============================================================
sqlldr test01/test01@172.16.XXX.XXX:1521/IWP control='readCSV.ctl'
============================================================
readCSV.ctl
============================================================
load data
infile 'temp.csv'
APPEND into table B_TEMP
FIELDS TERMINATED BY ","
trailing nullcols
(
USER_CD,
USER_NAME
)
============================================================