I'm using SQL* Loader to load bulk data from a comma delimited file.
The structure of this delimied file goes like this :
<header info>
<actual records to be inserted>
header info: comprises of a field containing a date
I need to get this date from the header info of this file and insert
it as the last field in all the inserts which form the next part of
the same comma delimited file.
e.g sample contents of the delimited file.
Date : 22-Nov-2002 - forms header Info
abc, def, ghi, 1, 2, 3 - forms actual records to be inserted
pqr, ghi, tef, 8, 6, 7 -do-
wxy, lmn, abc, 6, 6, 9 -do-
.
.
.
what I need is to insert this date : 22-Nov-2002 as the last column in
all the records.
abc, def, ghi, 1, 2, 3, 22- Nov-2002
pqr, ghi, tef, 8, 6, 7, 22- Nov-2002
wxy, lmn, abc, 6, 6, 9, 22- Nov-2002
If SQL Loader can't do this, I'm prepared to take up any work-arounds.
so pls do mention them too.
TIA
rgds,