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