Oracle PL/SQL Tutorial/System Tables Data Dictionary/nls parameters

Query v$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>