Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql loader leading zero issue in date format.

rahul.r.singhFeb 25 2020 — edited Feb 26 2020

Hi All,

I have data in below format 3142016 so the mm having no leading zero so I have changed in below format and it is working fine in database but not working in sql loader getting below error.

let me know how to solve this issue.

SELECT to_date(to_char(3142016,'09099999'),'MMDDYYYY') from dual

Added on Feb 25 2020

#database-key-features, #export-import-sql-loader-external-tables

2 comments

1,055 views