Search notes:
SQL Developer: Tools -> Preferences -> Database -> NLS
Tools -> Preferences -> Database -> Advanced allows to modify the following NLS related settings:
The German translation for this menu is Extras -> Voreinstellungen -> Datenbank -> NLS.
Settings that can be modified:
Setting | Example Value |
Language | ENGLISH |
Sort | BINARY |
Date Language | ENGLISH |
Date Format | yyyy-mm-dd hh24:mi:ss |
Timestamp Format | yyyy-mm-dd hh24:mi:ssXff |
Timestamp TZ Format | yyyy-mm-dd hh24:mi:ssXff tzr |
Decimal Separator | . |
Currency | SFr. |
Length | BYTE |
Territory | SWITZERLAND |
Comparison | BINARY |
Group Separator | ' |
ISO Currency | SWITZERLAND |