Skip to Main Content
Forums

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!

how to format char to number in sql loader control file

2629172Apr 4 2015 — edited Apr 9 2015

I tried to load a huge Excel csv file into oracle database with sql loader. But one column contains number of year like '2014', '2015'. In control file, I defined as:

column_name decimal external (38) "TO_NUMBER (:column_name, '9999')".

It awlays say:ORA-01722 invalid number format. I changed different number format. It all didn't work. Please help me on this.

1. The table column data type is number (38,0)

2. The data in csv file looks like this:  colored is the number of year.

03/04/15, D_2-15,10953562,11116,27144,03/03/15,2015

03/04/15, P_1-58,1143088,5262,12994,03/03/15,2015

03/04/15, Q_1-31_Distinct_WWE,7576633,22352,52975,03/03/15,2015

Thanks in advance.
This post has been answered by Solomon Yakobson on Apr 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2015
Added on Apr 4 2015
#database-key-features, #export-import-sql-loader-external-tables
21 comments
22,491 views