首页 > 代码库 > sqlldr

sqlldr

1、控制文件:

load data
infile ‘data.txt‘
append into table CustBasicInfo
Fields terminated by ‘,‘
(
CustId "‘ZJYDTZ‘||:CustId",
CustTel,
field1 Filler,
field2 Filler,
County,
CustLevel,
Telmanager,
CompanyCode Constant ‘TZYD‘,
ServiceTypeTel Constant ‘1‘,
Status Constant ‘1‘,
RecvSms Constant ‘0‘,
Memo Constant ‘20141223‘
)

2、调用文件:

sqlldr telmanager/world@A192.168.1.34 control=data.ctl

3、数据文件:

7613060497,183,7613060497,576,5767,14,tzll

 

参考:

http://www.blogjava.net/xzclog/archive/2010/03/24/316471.html


7612584697,182,7612584697,576,5766,14,tzll

 

sqlldr