DATABASE_PROPERTIES 查询数据库的属性参数

查询数据库的属性参数

DATABASE_PROPERTIES

DATABASE_PROPERTIES lists Permanent database properties.

Column Datatype NULL Description
PROPERTY_NAME VARCHAR2(30) NOT NULL Property name
PROPERTY_VALUE VARCHAR2(4000)   Property value
DESCRIPTION VARCHAR2(4000)   Property description

 

 

 


select property_name ,property_value from database_properties;

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ -----------------------------------
DICT.BASE                      2
DEFAULT_TEMP_TABLESPACE        TEMP
DEFAULT_PERMANENT_TABLESPACE   USERS
DEFAULT_EDITION                ORA$BASE
Flashback Timestamp TimeZone   GMT
TDE_MASTER_KEY_ID
DST_UPGRADE_STATE              NONE
DST_PRIMARY_TT_VERSION         14
DST_SECONDARY_TT_VERSION       0
DEFAULT_TBS_TYPE               SMALLFILE
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               AL32UTF8
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              11.2.0.4.0
GLOBAL_DB_NAME                 TESTDB
EXPORT_VIEWS_VERSION           8
WORKLOAD_CAPTURE_MODE
WORKLOAD_REPLAY_MODE
NO_USERID_VERIFIER_SALT        61FE9A498A8FB6995B77028E02D6C276
DBTIMEZONE                     00:00

36 rows selected.

 

上一篇:oracle函数 nls_charset_name(n1)


下一篇:oracle函数 TO_CHAR(x[[,c2],C3])