sql ldr 笔记

1，执行 语句
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')