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
|
LOAD DATA
INFILE 'file2.dat'
APPEND
INTO TABLE T1
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( n1,
n1_typ "DECODE(:n1_typ,'TEN',1,'NET',2)"
)
C:\>sqlldr xxx/xxx@xxx control=c2-1.ctl
SQL*Loader: Release 10.2.0.3.0 - Production on Wed Jan 16 10:21:32 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - logical record count 1
Commit point reached - logical record count 2
SQL> select * from t1;
N1 N1_
---------- ---
1 1
2 2 |
Partager