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.

Yes. But I would suggest External Tables depending on the number of rows in the files which you don't mention.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)