Query v$nls_parameters : nls_parameters « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. nls_parameters

SQL>
SQL> SELECT parameter, value
  2  FROM   v$nls_parameters
  3  where  rownum < 50
  4  ORDER BY parameter;

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CALENDAR
GREGORIAN

NLS_CHARACTERSET
WE8MSWIN1252

NLS_COMP
BINARY


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CURRENCY
$

NLS_DATE_FORMAT
DD-MON-RR

NLS_DATE_LANGUAGE
AMERICAN


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DUAL_CURRENCY
$

NLS_ISO_CURRENCY
AMERICA

NLS_LANGUAGE
AMERICAN


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE

NLS_NCHAR_CHARACTERSET
AL16UTF16

NLS_NCHAR_CONV_EXCP
FALSE


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NUMERIC_CHARACTERS
.,

NLS_SORT
BINARY

NLS_TERRITORY
AMERICA


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
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


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR


19 rows selected.

SQL>
SQL>