将.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 USERID=OFFICE/OFFICE@QH106 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 USERID=OFFICE/OFFICE@QH106 CONTROL=C:INPUT.CTL LOG=C:INTERVIEW.LOG
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271283/viewspace-998395/ ，如需转载，请注明出处，否则将追究法律责任。
