-
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
J.Scott Adams
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|