Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sqlloader question
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 Thu Jan 22 1998 - 00:00:00 CST