I have table with NUMBER(10,2) column (Oracle 11g).
Lets say the sample value is 123.34
When I export the data I get '123,24'. Finally my INSERT script gives an error trying to insert VARCHAR value into NUMBER column.
I have set Preferences/Database/NLS/Decimal Separator to . (dot)
How make SQLDeveloper use dot instead of comma while exporting NUMBER columns?
I've found it. All Export preferences are in: Preferences/Database/Utilities/Delimiter Format/Delimiter
If it doesn't work add
AddVMOption -Duser.region=US
in sqldeveloper.conf
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With