Re: Sqlloader question

[Quoted] Is it possible to load two tables at the same time if the primary key field in the first table is a foreign key field in the second table , but the primary key field number (a sequence in the definition file) is only generated during the load.

Declan

Jurij Modic wrote:

> On 22 Jan 1998 15:03:35 GMT, "thierry merlin" <t.merlin_at_citb.bull.net>
> wrote:
>
> >Hi,
> >
> >With one file ( file.data), I want to insert in two table at the same time.
> >Can I write this in my control file (file.ctl) :
> >Load Data
> >INFILE file.data
> >APPEND
> >
> >INTO TABLE table1
> >(CP_CP position(1:3) char,
> > CP_TOWN position( 10,15) char,
> > CO_CODE)
> >
> >INTO TABLE table2
> >( NAME position (4:9) char)
> >
> >Thank's for your help.
>
> Yes, you can! BTW, it's covered in one of the case examples in the
> Oracle RDBMS Utilities Guide.
>
> Regards,
> ============================================================
> Jurij Modic Republic of Slovenia
> jurij.modic_at_mf.sigov.mail.si Ministry of Finance
> ============================================================
> The above opinions are mine and do not represent any official
> standpoints of my employer
Received on Wed Jan 28 1998 - 00:00:00 CET