Home » SQL & PL/SQL » SQL & PL/SQL » How to load data into two tables from Ms-excel file using script
How to load data into two tables from Ms-excel file using script [message #227196] Tue, 27 March 2007 09:00 Go to next message
rupeshraju
Messages: 1
Registered: March 2007
Location: kolkata
Junior Member
Hi All,
I have a Ms-Excel sheet.I have to take it as a input file.From this file I have to insert different fields into two oracle tables with two different sequences.In addition to that the second table needs to contain the sequence value of first table for each corresponding row inserted.
For Example:

If the excel sheet contains below fields:
A B C D E
112 rupesh off kolkata WB

Now I want to insert the Fields A,B,E into table T1 with a sequence S1 as primary key for each row.

And then I want to insert the fields A,C,D into table T2 with a sequence S2 as primary key and also it should contain the value S1 table T1 for each corresponding row.

It should be like this:
Table T1 Table T2
-------- --------
S1 A B E S2 A C D S1
456 112 rupesh WB 789 112 off kolkata 456

Please help me out of this.Thanks in advance.
Re: How to load data into two tables from Ms-excel file using script [message #227210 is a reply to message #227196] Tue, 27 March 2007 09:36 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/146758/42800/?srch=sequence+sqlldr#msg_146758

http://www.orafaq.com/forum/m/209425/42800/?srch=sequence+sqlldr#msg_209425
Previous Topic: Help With Outer Joins
Next Topic: FLAG incorrectly set for Feb leap year
Goto Forum:
  


Current Time: Wed Dec 07 05:05:32 CST 2016

Total time taken to generate the page: 0.09741 seconds