|
| Name | Set SQL Developer's |
| Rating |  |
| Created On | 01-SEP-06 |
| Category | Preferences |
| Database Version | 9.2 |
| Description | From the forum:
"Unfortunately, because it doesn't rely on an Oracle client install, the NLS_LANG settings in your Oracle registry are ignored. Also, the Windows environment variable is ignored. The default is based on your Regional Options on the Regional and Language Options control in the Control Panel. Selecting from the nls_session_parameters view will tell you what your current settings are. To change the NLS language settings in SQL Developer you need to edit the .conf file - see http://forums.oracle.com/forums/thread.jspa?messageID=1363866�� "
The following steps result in userenv('LANG') from SQL developer returning 'US'.
1. Edit /jdev/bin/sqldeveloper.conf file.
2. Add the following parameters:
AddVMOption -Duser.language=en
AddVMOption -Duser.region=US
3. Restart SQL Developer.
|
|
|
|