Skip to Main Content

Oracle Database Discussions

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 Date Format

829995Jan 27 2011 — edited Jan 28 2011
Hello Everyone

I have 2 questions in loader

1) I need to convert date value, in csv file there is column called closed_date and value some time coming as null and sometime 20101122 22:12:07. I want to insert "YYYYMMDD HH24:MI:SS" this format.

2) when I try i load clob data type column using sql loader its giving no termination found for this column.

Could you please advice.

Thanks
Bhavana
This post has been answered by Tubby on Jan 27 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2011
Added on Jan 27 2011
9 comments
795 views