I just experienced that Oracle SQLDeveloper 1.5.1 has a bug, if you try to export a result as a insert-script.
The delimeters in the VALUE clause are dots instead of commas.
To fix this you have to change your preferences (Tools-Preferences-Database-NLS Parameters). There you set Group Seperator to , (comma) and change the Decimal Seperator to . (dot)
!!! it is important to change the Decimal Seperator as well - it wont work if Group- and Decimal Separator are the same !!!
I don't know why it doesn't work if you change the General Export Parameter to , (comma) but the workaround works just fine.
detect IT
maybe you have the same problems to solve ... keep smiling ;)
1 Response to export bug in SQLDeveloper 1.5.1
I run into the same problem. Thanks for the hint!
Something to say?