Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sqlloader question
Hi
You can do as you say. SQL LOADER is very powerful and it is worth reading up on.
Colin.
thierry merlin wrote in message
<01bd2746$ba6de480$3c4c5ac0_at_thierry.citb.bull.net>...
>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.
>
Received on Sat Jan 24 1998 - 00:00:00 CST