CODEWITHSUNDEEP
oracle-sqldeveloper
psmith
psmith

Reputation: 1813

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?

Upvotes: 7

Views: 6941

Answers (2)

Giovani Soares
Giovani Soares

Reputation: 21

Look for Decimal Separator under Preferences > Database > NLS > Decimal Separator:

Decimal Separator

Also, you can use:

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' ;

...on your SQL Developer session.

https://datacadamia.com/db/oracle/nls_numeric_characters

Upvotes: 2

psmith
psmith

Reputation: 1813

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

Upvotes: 7

Related Questions