Thursday, May 29, 2003, 6:00:49 PM, Bob wrote:
BM> Thanks for answering my question. I diddnt realise you could
BM> querry colums ahead of the current line.
As I recall, it took me a long time to realize that too.
It may help to realize that everything you type between
double-quotes (those
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
All
Im need to concatenate my log_date and log_time field (the 2
physical records into one logical record).
I can find how to do it with a fixed length file but my case is a
delimited file. Looking at the docs, it seems the continueif is used for
delimited dtaa, I cant seem to get the syn
