sqlldr user/pwd@serviceName control=load.ctl
load data
infile 'C:\Documents and Settings\Administrator\桌面\数据文件.txt'
append into table tableName //append 或者 replace
fields terminated by ';' //分隔符
(
EMAIL CHAR,
GENDER CHAR,
AGE CHAR
)
sqlldr user/pwd@serviceName control=load.ctl
load data
infile 'C:\Documents and Settings\Administrator\桌面\数据文件.txt'
append into table tableName //append 或者 replace
fields terminated by ';' //分隔符
(
EMAIL CHAR,
GENDER CHAR,
AGE CHAR
)