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