Database_Properties

SQL> col property_name format a25
SQL> col property_value format a40
SQL> select property_name, property_value from database_properties
2 order by 1;
PROPERTY_NAME PROPERTY_VALUE
------------------------- ----------------------------------------
DBTIMEZONE 00:00
DEFAULT_PERMANENT_TABLESP USERS
DEFAULT_TBS_TYPE SMALLFILE
DEFAULT_TEMP_TABLESPACE TEMP
DICT.BASE 2
EXPORT_VIEWS_VERSION 8
GLOBAL_DB_NAME ORCL1
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_COMP BINARY
NLS_CURRENCY $
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_DUAL_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_LANGUAGE AMERICAN
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS .,
NLS_RDBMS_VERSION 10.1.0.2.0
NLS_SORT BINARY
NLS_TERRITORY AMERICA
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFFAM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AMTZR
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
27 rows selected.