SQL & PL/SQL

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!

how to load date column from .csv using SQLLDR

greddyNov 6 2006 — edited Nov 6 2006

Hi,

I have a table with a date column.

I have a .xls file which containes date values in single column like

11/5/2006
12/5/2006
..............
.............

02/02/2116

how to load them into a table's date column using SQLLDR ?

i know that i have to save the .xls file as .csv

but how to insert the values which have "/" in the date format into the date column?
and what should be the session's nls_date_format setting before i load this data?

any ideas please

Thanks
greddy

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2006

Added on Nov 6 2006

3 comments

1,005 views