++++++sqlldr语法++++++++
sqlldr userid=inside/insidepwd@10.98.18.250 direct=true control=F:\CAINFO\cainfo.ctl log=F:\CAINFO\cainfo.log
++++++控制文件cainfo.ctl+++++++
load data
infile 'F:\CAINFO\import.csv'
replace
into table t_mailbox_corp
fields terminated by ','
trailing nullcols
(MAILBOX_NAME,
REG_CODE
)
没有评论:
发表评论