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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 25 2011

Added on Jan 27 2011

#general-database-discussions

9 comments

795 views