SQL Loader ?????

[abhijit]

Hi all!

Is it possible to load more than one table from one control file in one sql loader statement. eq.

I got ten fields in my input file (P1 to P10). I got two tables (Table1 and Table2) where I want to load data. Values P1->P5 should go to Table1 and rest of data i.e. P6->P10 should populate in Table2. This should be done in one execution.

Appreciate your view in advance.

abhijit

[vidhya]

Yes, you can load multiple tables using one control file.

Example:
LOAD DATA

INFILE 'example1.dat'

BADFILE 'example1.bad'

DISCARDFILE 'example1.dsc'

APPEND/REPLACE

INTO TABLE table1

(p1 POSITION(1:4) INTEGER EXTERNAL,
p2 POSITION(6:15) CHAR,
....)

INTO TABLE table2
WHEN p5 != ' '

(p5 POSITION(25:27) INTERGER EXTERNAL,
p6 POSITION(28:30) CHAR,
......)

i hope this helps.

vidhya

[abhijit]

Thanks a lot Vidhya.

abhijit