Dear Masters
I am trying to load data through sql loader.
My input file has blanks at some places where the data type in the table is of type DATE
How do i handle this in the sqlloader. I want to load system date whenever the DATE filed is blank in the infile.
I have written the query as

load data
infile "filename.csv"
replace
into table table_name
fields terminated by ","
trailing nullcols
(
Field1 char,
Field2 "decode(:Field2, null,sysdate,:Field2)
)


Regards
Shadab

Oracle LazyDBA home page