2 Replies Latest reply: Dec 6, 2012 11:13 PM by 971895 RSS

    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

      Please advice