sqlldr 控制文件样例
load data
infile 'C:\Documents and Settings\Administrator\桌面\20100414\dbo.messageSender.csv'
into table messageSender
truncate
fields terminated by ","
TRAILING NULLCOLS
(
MessageID char,
SendTime DATE "YYYY-MM-DD HH24:MI:SS",
SenderType,
SenderName,
Caption char(1000),
Content char(10000)
)
infile 'C:\Documents and Settings\Administrator\桌面\20100414\dbo.messageSender.csv'
into table messageSender
truncate
fields terminated by ","
TRAILING NULLCOLS
(
MessageID char,
SendTime DATE "YYYY-MM-DD HH24:MI:SS",
SenderType,
SenderName,
Caption char(1000),
Content char(10000)
)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11780477/viewspace-705072/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11780477/viewspace-705072/