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!

Load formatted number to db using SQLLDR

Andy1785Jun 14 2012 — edited Jun 15 2012

Hi all,

We are trying to load data to oracle database from csv file using sqlldr. We are able to load everything succesfully except amount where we have numbers in the following format :

($633,000.00) --- negative number
$633,000.00 --- positive number.

Is there a way we can load this to oracle db using sqlldr by defining someting in controlfile?

Please advice.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2012

Added on Jun 14 2012

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

5 comments

6,165 views