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 control=data.ctl

3、数据文件：

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

 

参考：

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