Changing NLS Parameter Values

You can change the value of one or more NLS parameters in any of these ways:

Change the values for all SQL Developer connections, current and future.
On the client, change the settings of the corresponding NLS environment variables.

Only on the client, the new values of the NLS environment variables override the values of the corresponding NLS parameters.

You can use environment variables to specify locale-dependent behavior for the client. For example, on a Linux system, this statement sets the value of the NLS_SORT environment variable to FRENCH, overriding the value of the NLS_SORT parameter:
```
% setenv NLS_SORT FRENCH
```
Note: Environment variables might be platform-dependent.
Change the values only for the current session, using an ALTER SESSION statement with this syntax:
```
ALTER SESSION SET parameter_name=parameter_value
  [ parameter_name=parameter_value ]... ;
```
Only in the current session, the new values override those set in all of the preceding ways.

You can use the ALTER SESSION to test your application with the settings for different locales.
Change the values only for the current SQL function invocation.

Only for the current SQL function invocation, the new values override those set in all of the preceding ways.

This section contains:

Related Topics