Re: Sqlloader question
From: Colin Sutherland <colin.sutherland_at_easynet.co.uk>
Date: 1998/01/24
Message-ID: <6aclqk$nkr$1_at_apple.news.easynet.net>#1/1
Date: 1998/01/24
Message-ID: <6aclqk$nkr$1_at_apple.news.easynet.net>#1/1
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 CET