SQL Loader: Selective Import query.

From: <punitparikh_at_gmail.com>
Date: 18 May 2005 01:31:45 -0700
Message-ID: <1116405105.933646.72370_at_g44g2000cwa.googlegroups.com>

[Quoted] [Quoted] I am planning to use SQL Loader to import data present in csv files to [Quoted] 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. Received on Wed May 18 2005 - 10:31:45 CEST

This message: [ Message body ]
Next message: Tor Hovland: "NullPointerException when logging on to Enterprise Manager"
Previous message: its not me: "Re: oracle forms style template"
Next in thread: Rauf Sarwar: "Re: SQL Loader: Selective Import query."
Reply: Rauf Sarwar: "Re: SQL Loader: Selective Import query."
Reply: DA Morgan: "Re: SQL Loader: Selective Import query."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message