-
How to load data into Multiple tables through SQL*Loader ?
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
SUROOP B
-
The manual has a "case study" for loading into multiple tables. What don't you understand?
-
I got it Dapi,Thanks
Kishan
SUROOP B
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|