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 |