Re: inserting data from file #2

Vince <vincent@ 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

Once possibility is to dynamically write the control file using UTL_FILE. I have an example in Morgan's Library at www.psoug.org. Click on UTL_FILE.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)