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
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