sqlldr tktdev/tktdev@ttlorae1 control=dhjcityline.ctl log=dhj.log
2,控制语句
load data
infile 'cityline.txt'
truncate
into table dhjaireline
fields terminated by ',' optionally enclosed by '"'
(id ,
airecode ,
origincity ,
destinationcity ,
arrivetime DATE 'YYYY-MM-DD HH24:MI:SS')