Re: Sqlloader question

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/01/22
Message-ID: <34c7a3d4.6427746_at_www.sigov.si>#1/1

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 CET