Help: Parent-Child relation in Sql-Loader

Greetings,

           I have 3 tables in oracle (say t1, t2, t3)

t1:
name1
seq_no

t2:
name2,
seq_no,

t3:
name3
seq_no

I am loading these tables using sql-loader.

I am using SEQUENCE(MAX,1) in order to load unique sequences in seq_no column of t1.

I want the same sequence values to be inserted to t2(seq_no) and t3(seq_no) irrespective of already loaded values.

I want something like this:

t1:

name1	seq_no
H	500
J	501

t2:
name2	seq_no
S	500
R	501

t3:
name3	seq_no
T	500
Q	501

Is this possible?

Help would be appreciated

TIA Received on Fri Mar 02 2007 - 08:43:56 CST