bat txt数据导入数据库

1.txt文件

2.编写input.ctl

load data
infile '需剔除的清单.txt'
append into table dhhm_temp_20130509
fields terminated by '|' trailing nullcols
(
dhhm
 )
3.bat编写

@echo off
sqlldr userid=**/***@dxqf control=input.ctl

pause