Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>