Export NUMBER from SQLDeveloper - comma instead of dot

Viewed 5666

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?

2 Answers
Related