SQLLDR的一個筆記

將.xls檔案用製表符分隔形式儲存為C:INTERVIEW.txt

建立c:input.ctl如下：
load data
infile 'C:INTERVIEW.txt'
append into table INTERVIEW_TMP
fields terminated by X'09' TRAILING NULLCOLS
(NAME,CELL_PHONE,HOME_PHONE,ADDRESS,BACHELOR)

c:>SQLLDR CONTROL=C:INPUT.CTL LOG=C:INTERVIEW.LOG

[@more@]

將.xls檔案用製表符分隔形式儲存為C:INTERVIEW.txt

建立c:input.ctl如下：
load data
infile 'C:INTERVIEW.txt'
append into table INTERVIEW_TMP
fields terminated by X'09' TRAILING NULLCOLS
(NAME,CELL_PHONE,HOME_PHONE,ADDRESS,BACHELOR)

c:>SQLLDR CONTROL=C:INPUT.CTL LOG=C:INTERVIEW.LOG