like this:
load data
infile '..'
append into table tab_name
fields terminated by ..
(
..
col date "to_date(:col,'yyyy-mm-dd hh24:mi:ss')"
..
)如果你表中的字段为date的话,大多情况下即使不指定date ...也可以正常导入
load data
infile '..'
append into table tab_name
fields terminated by ..
(
..
col date "to_date(:col,'yyyy-mm-dd hh24:mi:ss')"
..
)如果你表中的字段为date的话,大多情况下即使不指定date ...也可以正常导入
infile 'c:/test.csv'
into table test
fields terminated by ','OPTIONALLY ENCLOSED BY '"'
(时间 date "yyyy-mm-dd hh24:mi:ss",
状态
)
sqlldr user/passwd control=f:\test.ctl