PDA

View Full Version : SQL Loader: Selective Import query.

Guest
05-18-2005, 12:31 AM
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.
Rauf Sarwar
05-18-2005, 06:22 AM
punitparikh@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
DA Morgan
05-18-2005, 10:13 AM
punitparikh@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@x.washington.edu
(replace x with u to respond)

MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service