This discussion is archived
2 Replies Latest reply: Dec 6, 2012 9:13 PM by 971895 RSS

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

kaminanikamini Newbie
Currently Being Moderated
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

Please advice

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points