SQL LOADER... URGENT HELP !!! [message #329381] |
Wed, 25 June 2008 04:52 |
kvivek@techmahindra.com
Messages: 2 Registered: June 2008
|
Junior Member |
|
|
I have a data file that looks like:
REC001;TO_NAME;TO_ADDR;TO_PHONE
REC002;ITEM_ID1;DATE_DELIVERED1
REC002;ITEM_ID2;DATE_DELIVERED2
REC002;ITEM_ID3;DATE_DELIVERED3
REC002;ITEM_ID4;DATE_DELIVERED4
i want to load this in the Database using SQL LOADER in this format:
NAME | ADDR | PHONE | ITEM | DATE DELIVERED
-------------------------------------------------
TO_NAME TO_ADDR TO_PHONE ITEM_ID1 DATE_DELIVERED1
TO_NAME TO_ADDR TO_PHONE ITEM_ID2 DATE_DELIVERED2
TO_NAME TO_ADDR TO_PHONE ITEM_ID3 DATE_DELIVERED3
TO_NAME TO_ADDR TO_PHONE ITEM_ID4 DATE_DELIVERED4
Basically i want the name, addr, phone from REC001 to be repeated every time i load REC002.
Any help on how to do this.
|
|
|
Re: SQL LOADER... URGENT HELP !!! [message #329384 is a reply to message #329381] |
Wed, 25 June 2008 05:12 |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
And how urgent is your requirement because we have huge back log and it will approximately 2 light years to attend any urgent request and for normal request it will be attended when the next forum member become available.
Since this being your first post I will suggest you to read the forum guidelines before posting.
For your kind of requirement it will lot more easier by doing it using external tables rather than sql*loader. For more information on how to use external tables check the oracle reference manual under utilities section.
Also from next time it will be lot more useful to avoid the word "URGENT" as it will attract wrong attention like what I have just lectured above and also post some sample data, insert scripts and the expected output.
Regards
Raj
|
|
|
|
|