selective loading from csv files

From: Ram Kalapatapu <ram_at_paganini.vron1.nj.home.com>
Date: Thu, 22 Apr 1999 18:38:21 GMT
Message-ID: <slrn7hud2u.14b.ram@paganini.vron1.nj.home.com>

Hi,
sqlldr seems to be very versatile (compared to sybase bcp). I wonder if it is possible to do the following:
Given a file with variable length data (say in csv format), is it possible to have the sqlldr ignore certain columns of data? Eg
Consider the following rows of data
"SUNW",61.5,"4/22/1999","12:58PM",+2,62.875,63.125,60.5,9876900
"MSFT",84.125,"4/22/1999","12:58PM",+2.125,85,85.25,83.375,17209700
Col1 is ticker symbol,
Col2 is price,
COl3 is date,
col4 is time,
col5 is price change,
....etc

Suppose I have a table with the following definition: create table stock_price_watch_tb

(     
ticker varchar(6),          
price number,          

timestamp date,
days_price_change number,
volume number)

I am interested in loading only col1,col2,col5,col9. How do I write ctl format for this case. I know life would have been easier if it was fixed format but...!

Thanks for your help
--Ram Received on Thu Apr 22 1999 - 13:38:21 CDT