Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Loader: Selective Import query.
Użytkownik punitparikh_at_gmail.com napisał:
> 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.
If you're planning to use, then you should first learn about SQL Loader, control file, and ask us where help to Loader is located. And most of answers, you get is FUT help at thaiti.com i bet.
> 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?
Yes, it would be better, import all columns, most of them you find useful in the future.
-- NoelReceived on Wed May 18 2005 - 03:40:28 CDT