Skip to Main Content

SQL Developer

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!

Database export. Comma used as decimal causes errors

user467837Jun 9 2011 — edited Jun 10 2011
I used Tools -> Database export... to export a table and it's data. The format I chose was "insert".

When I ran the created _data.sql file I kept getting "too many values" errors.

The reason is that my number columns have values like 0,23 and this is not being quoted or anything (i.e. the insert line looks something like blalbla,0,23,blabla).

What I'm trying to say is that my locale uses a comma and not a period as a decimal and SQL Developer does nothing to handle it in the export. This is a pretty serious bug in my opinion and needs to be fixed.


regards,
Dagur
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2011
Added on Jun 9 2011
5 comments
904 views