sql loader control file help..........
Posted on 2007-03-20
I need help for sql ldr control file -
I need to load data from a file into a table, but need to add a constant to each row -
Here is my control file -
into table tb_load
(DATA_RECORD POSITION(1:621) CHAR)
Above control file works and all data loaded as expected, now, I need to add a constant to each record while loading, so I tried to modify control file as below -
into table tb_vc_load
(DATA_RECORD CONSTANT '18' || POSITION(1:621) CHAR)
But, above control file gets a syntax error on ||
Can someone help? How can I add a constant while adding the data file into my table, basically for every record I need constant 18 then data record.