V$NLS_PARAMETERS

V$NLS_PARAMETERS contains current values of NLS parameters.

Column Datatype Description
PARAMETER VARCHAR2(64) Parameter names are as follows: NLS_CALENDAR, NLS_CHARACTERSET, NLS_COMP, NLS_CURRENCY, NLS_DATE_FORMAT, NLS_DATE_LANGUAGE, NLS_DUAL_CURRENCY, NLS_ISO_CURRENCY, NLS_LANGUAGE, NLS_LENGTH_SEMANTICS, NLS_NCHAR_CHARACTERSET, NLS_NCHAR_CONV_EXCP, NLS_NUMERIC_CHARACTERS, NLS_SORT, NLS_TERRITORY, NLS_TIMESTAMP_FORMAT, NLS_TIMESTAMP_TZ_FORMAT

Two additional parameters, NLS_TIME_FORMAT and NLS_TIME_TZ_FORMAT, are currrently used for internal purposes only.

VALUE VARCHAR2(64) NLS parameter value