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>
