Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export NUMBER from SQLDeveloper - comma instead of dot

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?

like image 758
psmith Avatar asked Mar 16 '16 06:03

psmith


1 Answers

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

like image 119
psmith Avatar answered Oct 01 '22 17:10

psmith