In the CONTROL file that describes the columns to load from the data file you can load
a FILLER type column desc into the destination table if the column does not exist in
the source data file. If the source data column contains nulls then a NVL will convert
a null to what ever you want to plac
Hi,
Take a look at the nullif clause.
tom
-Original Message-
Sent: Tuesday, May 29, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank column into a date column...
this throws out an error...and the loader fails...do you know of a way of
how
to get around this problem...how can I just