Hi Jonathan
Thanks for answering my question. I diddnt realise you could
querry colums ahead of the current line.
Ive applied functions (in a ctl file) to the current column, but diddnt
realise I could || the next column
My working ctl file
Thanks again
bob
LOAD DATA
INFILE 'F:\11NETS
Hello Bob,
My first thought is to try something like:
...
log_date CHAR
"TO_DATE(:log_date || ' ' || :log_time,'ddMon hh:mi:ss'",
log_time FILLER char,
...
I may not have the syntax just right, and I can't take time
to test it until later this evening (shouldn't be reading
ORACLE-L now any
