SQLLDR reusing column records

From: Jim <shija03_at_hotmail.com>
Date: 5 Sep 2003 10:08:31 -0700
Message-ID: <28311b05.0309050908.7bde8945_at_posting.google.com>

[Quoted] I have a file that contains several records where each field is delimited by commas:

'field1','field2','field3','field4',

ie:
'aaa','b','c','d',
'aaaaaaaa',bbb','','ffff',

I would like to use sqlldr to load the file into a table placing each record's field in the following fashion:

LOAD DATA
APPEND
INTO TABLE mytable
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(

   column1 field1
   column2 field2
   column3 field3
   column4 field2
   column5 field2
   column6 field3
)

Thank you Received on Fri Sep 05 2003 - 19:08:31 CEST