Changing NLS Parameter Values for All SQL Developer Connections

The following procedure shows how to change the values of NLS parameters for all SQL Developer connections, current and future.

To change National Language Support Parameter values:

1. In the SQL Developer window, click the menu Tools.

   A drop-down menu appears.

2. From drop-down menu, select Preferences.

   The Preferences window opens.

3. In the Preferences window, expand Database.

   A list of database preferences appears.

4. Click NLS Parameters.

   A list of NLS Parameters and their current values appears. The value fields are drop-down menus.

5. From the drop-down menu to the right of each parameter whose value you want to change, select the desired value.

6. Click OK.

   The NLS parameters now have the values that you specified. To verify these values, see "Viewing NLS Parameter Values".