Hi,
I am trying to load several thousand records using
SQL Loader in Oracle 7.3.4

I am converting a string in the datafile to a date format
however there are several bad dates and Loader spits
out the whole record. is there a way in my control file to specify that if it runs across a bad date to make it "NULL"
instead of kicking out the whole record?

my syntax:
deed_date position(758:767) nullif(758:758)=" " "to_date(:deed_date,'RRRR MM DD')")

thanks,
scotta