Re: SQL Loader: Selective Import query.

punitparikh_at_gmail.com wrote:
> Hi
>
> I am planning to use SQL Loader to import data present in csv files
to
> Oracle 9i db. I have a few questions regarding SQL Loader.
> 1. Can i load selective columns from the csv file.
> i.e. csv format is something like this
>
> 4/27/1998,506,23,M508 RCW,TESCO,,,,,295/80R22.5,295/80R22.5
>
> out of which i just want to load 2nd and 4th column to a particular
> table. Is it possible? Or should the input file contain only the
> required columns to be imported?
>
> Also for such cases of selective import would External Tables be a
> better choice?
>
> Thanks in advance.
> Punit.

Use external tables. Gives you all the functionality in familiar SQL/PLSQL environment.
Alternatively you can lookup usage for "FILLER" keyword under SQL*Loader at http://tahiti.oracle.com

Regards
/Rauf Received on Wed May 18 2005 - 16:22:31 CEST