Re: SQL*Loader question

On Wed, 09 Mar 2005 01:08:34 -0800, Golan wrote:

> I want to use sql*loader in order to load a text file data into the
> database.
> The file may contain one different types of records (one of the fields
> is the record type) and each record type need to be loaded into a
> different table.
> Is it a way I can use the sql*loader for such a file?
>

The Utilities manual for the version of the database you are using has a section on SQL Loader. There are many case studies, with code, in that manual - available from http://docs.oracle.com

I mention this because this kind of question generally leads to a series of others - that happen to be answered in the docco.

And yes, you can do this. Use multiple 'INTO table' clauses coupled with appropriate 'WHEN' clauses to select the appropriate INTO.

hth/FGB Received on Wed Mar 09 2005 - 09:37:03 CST