sqlldr 增加常量字段

abc.txt內容如下：

aa bb

aa1 bb1

aa2 bb2

 

sqlldr到數據的效庫要如下：

c1 aa bb

c1 aa1 bb1

c1 aa2 bb2

 

input.ctl的寫法

LOAD DATA
INFILE 'abc.txt'

append INTO TABLE TABLE_NAME
FIELDS TERMINATED BY X'09'
(FIELD1 constant "c1",FIELD2,FIELD3)