How to load data into Multiple tables through SQL*Loader ?

[bsuroop]

Hi Friends,

How can I load data into multiple tables (Oracle database) through SQL*Loader with a comma delimited file.

Example
-------

Table A
-------
Code Number,
Name Varchar2(15)


Table B
-------
Code Number,
Name Varchar2(15)


Table C
-------
Code Number,
Name Varchar2(15)


Flat File Data:
---------------
10,JOHNSON
20,ANTHONY
30,JAMES

The value starting with 10 should be loaded into Table A
The value starting with 20 should be loaded into Table B
The value starting with 30 should be loaded into Table C


If you can give the script it will be very helpful.


Thanks in Advance,
Kishan

[DaPi]

The manual has a "case study" for loading into multiple tables. What don't you understand?

[bsuroop]

I got it Dapi,Thanks
Kishan