Viewing NLS Parameter Values

To view the current values of NLS parameters, use either the SQL Developer report National Language Support Parameters or this query:

SELECT * FROM V$NLS_PARAMETERS;

To view the National Language Support Parameters report:

1. In the SQL Developer window, click the tab Reports.

   The Reports pane shows a list of reports.

2. Expand Data Dictionary Reports.

   A list of data dictionary reports appears.

3. Expand About Your Database.

   A list of reports appears.

4. Click National Language Support Parameters.

   The Select Connection window opens. It has a Connection field with a drop-down menu.

5. From the drop-down menu, select hr_conn.

6. Click OK.

   The Select Connection window closes and the National Language Support Parameters pane appears, showing the names of the NLS parameters and their current values.