Re: inserting data from file #2

From: <fitzjarrell_at_cox.net>
Date: 13 May 2005 08:50:00 -0700
Message-ID: <1115999400.419418.200560@g49g2000cwa.googlegroups.com>

Vince wrote:
> Hello there !
>
> okay...apparently, no way to bulk insert data from file using a SQL
> statement. I must use sql*loader. But sql*loader uses a control file
> where is written the target table and I need to make target table
> variable.
> How could I proceed easily ?
>
> thanks a lot.
> ++
> Vince

Making the 'target table variable' does more than simply change the INTO TABLE clause, it also changes the column list, unless, of course, you have every table named differently but created with exactly the same columns.

You do not mention WHICH operating system youo're using, so it is difficult to provide a solution. Also, you do not mention which release of Oracle, making it even more difficult to offer possibilities (such as using external tables).

Provide the requested information if you want a usable response.

David Fitzjarrell Received on Fri May 13 2005 - 10:50:00 CDT