scott@9i > create table parent (c1 number primary key,c2 varchar2(30));

Table created.

scott@9i > create table child (c1 number references parent(c1), c2 varchar2(30));

Table created.

scott@9i > create sequence MySequence start with 1 increment by 1;

Sequence created.

oracle@mutation#cat myctl.ctl
LOAD DATA
INFILE 'mydata.data'
insert
INTO TABLE parent
when (1:1) = 'p'
fields terminated by ',' optionally enclosed by '"' trailing nullcols
(c1 position(1:2) "MySequence.nextval",
 c2 )
into TABLE child
when (1:1) = 'c'
fields terminated by ',' optionally enclosed by '"' trailing nullcols
(c1 position(1:2) "MySequence.currval",
c2 )

oracle@mutation#cat mydata.data
p,parentrecord1
c,childrecord1
p,parentrecord2
c,childrecord2
p,parentrecord3
c,childrecord3
p,parentrecord4
p,parentrecord5
c,childrecord4
c,childrecord5

oracle@mutation#sqlldr userid=scott/tiger control=myctl.ctl rows=1

SQL*Loader: Release 9.2.0.4.0 - Production on Sun Nov 13 20:52:36 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 1
Commit point reached - logical record count 2
Commit point reached - logical record count 3
Commit point reached - logical record count 4
Commit point reached - logical record count 5
Commit point reached - logical record count 6
Commit point reached - logical record count 7
Commit point reached - logical record count 8
Commit point reached - logical record count 9
Commit point reached - logical record count 10

oracle@mutation#query mutation scott.parent

        C1 C2
---------- ------------------------------
         3 parentrecord3
         4 parentrecord4
         5 parentrecord5
         1 parentrecord1
         2 parentrecord2

oracle@mutation#query mutation scott.child

        C1 C2
---------- ------------------------------
         3 childrecord3
         5 childrecord4
         5 childrecord5
         1 childrecord1
         2 childrecord2

oracle@mutation#