SQL*Loader - How to load only a few columns from a .csv file to ora table

Hi there,

Could anyone please let me know how to load few columns from a .csv file into a oracle table using SQL*Loader.

I know how to create a .dat and .ctl file and run the sql loader.

Suppose I have a .csv file with

col1, col2, col3, col4

and I only need to load col1 and col3 into col_a and col_b respectively in table_a?

structure of table_ a

col_a, 
col_b, 
col_3  

Please advice

sunv Received on Thu Apr 21 2005 - 14:04:53 CDT