1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
create table test2(a number, b number);
test22.ctl
options (SILENT=(HEADER, FEEDBACK),errors=1,rows=10000)
LOAD DATA APPEND
Into table test2
When A='1'
( A POSITION(1:1),
B POSITION(3:3)
)
Into table test2
When A='2'
(
A POSITION(1:1),
B POSITION(3:3)
)
test2.ctl
options (SILENT=(HEADER, FEEDBACK),errors=1,rows=10000)
LOAD DATA APPEND
Into table test2
When A = '1'
FIELDS TERMINATED BY '|'
(
A ,
B
)
Into table test2
When A = '2'
FIELDS TERMINATED BY '|'
(
A ,
B
)
test2.dat
1|5
2|6
3|7
1|8 |