About Initial NLS Parameter Values

Except in SQL Developer, the initial values of NLS parameters are set by database initialization parameters. The DBA can set the values of initialization parameters in the initialization parameter file, and they take effect the next time the database is started.

In SQL Developer, the initial values of NLS parameters are as shown in Table: Initial Values of NLS Parameters in SQL Developer.

Initial Values of NLS Parameters in SQL Developer

Parameter	Initial Value
`NLS_CALENDAR`	`GREGORIAN`
`NLS_CHARACTERSET`	`AL32UTF8`
`NLS_COMP`	`BINARY`
`NLS_CURRENCY`	`$`
`NLS_DATE_FORMAT`	`DD-MON-RR`
`NLS_DATE_LANGUAGE`	`AMERICAN`
`NLS_DUAL_CURRENCY`	`$`
`NLS_ISO_CURRENCY`	`AMERICA`
`NLS_LANGUAGE`	`AMERICAN`
`NLS_LENGTH_SEMANTICS`	`BYTE`
`NLS_NCHAR_CHARACTERSET`	`AL16UTF16`
`NLS_NCHAR_CONV_EXCP`	`FALSE`
`NLS_NUMERIC_CHARACTERS`	`.,`
`NLS_SORT`	`BINARY`
`NLS_TERRITORY`	`AMERICA`
`NLS_TIMESTAMP_FORMAT`	`DD-MON-RR HH.MI.SSXFF AM`
`NLS_TIMESTAMP_TZ_FORMAT`	`DD-MON-RR HH.MI.SSXFF AM TZR`
`NLS_TIME_FORMAT`	`HH.MI.SSXFF AM`
`NLS_TIME_TZ_FORMAT`	`HH.MI.SSXFF AM TZR`

These and other NLS parameter values, which are used for all sessions in SQL Developer (such as SQL Worksheet windows and the National Language Support Parameters report, for all connections) are visible in the Database: NLS Parameters preferences pane.

To change the value of any NLS parameter, you have the following options:

Change the value for use with all SQL Developer connections (current and future) by using the Database: NLS Parameters preferences pane.
Change the value for the current connection only by using the ALTER SESSION statement in the SQL Worksheet window.

Thus, you have great flexibility in testing different language settings during database application development. For example, you can use ALTER SESSION to see the output of subsequent PL/SQL statements with different language settings, and then revert to the SQL Developer default settings by disconnecting and reconnecting.

For example, assume that the NLS_LANGUAGE value in the preferences is set to FRENCH, and that today is March 1, 2007. If you enter SELECT sysdate FROM dual; in the SQL Worksheet and click the Run Script icon, the output is:

SYSDATE                   
------------------------- 
01-MARS -07

If you enter ALTER SESSION SET NLS_LANGUAGE='AMERICAN'; and enter the preceding SELECT statement again, the output is:

SYSDATE                   
------------------------- 
01-MAR-07

Continuing with this example, if you disconnect from the current connection and reconnect to it, the session NLS_LANGUAGE value is FRENCH (as specified in the preferences), and the SELECT statement output is:

SYSDATE                   
------------------------- 
01-MARS -07