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!

Values with trailing minus in sql*loader data file

851268Sep 29 2011 — edited Oct 4 2011

Hi All,

I am facing issues with data file that gets parses through sql*loader utility and loads the data into one of the oracle tables.
In the data file, there are some values containing minus at the end of the value, which is not getting parsed through sql*loader control file and resulting in INVALID NUMBER error.

They are all number datatypes in the final Oracle table.

Data looks like

|||||||||||||881.02-|88.20-|2016.02||||||||||

Is their any kind of formatting that can be done at the control file level such that it reads

|||||||||||||881.02-|88.20-|2016.02||||||||||

|||||||||||||-881.02|-88.20|2016.02||||||||||

and loads it into the Oracle table.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2011

Added on Sep 29 2011

#control, #database-key-features, #export-import-sql-loader-external-tables, #file, #linux, #oracle, #sql

5 comments

2,393 views