Wednesday, December 09, 2009

SQL Loader ( Sample )

** command line **
sqlldr xxx/yyyy control=zzz.par data=zzz.dat log=zzz.log

** Control File **

LOAD DATA
APPEND
INTO TABLE ZZZZ
(
TID "zzz_seq.nextval",
START position(17:25),
STOP position(33:41),
BARBY CONSTANT "ZZZ"
)

** Data File **
021234567
022345678
023456789
021111111



== TaTsHuYa ==

No comments: