DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.DATABASE_PROPERTIES

Object Details
Object Name: DATABASE_PROPERTIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Permanent database properties

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPERTY_NAME VARCHAR2 (128) Yes Property name
PROPERTY_VALUE VARCHAR2 (4000)
Property value
DESCRIPTION VARCHAR2 (4000)
Property description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROPERTY_NAME
,      PROPERTY_VALUE
,      DESCRIPTION
FROM SYS.DATABASE_PROPERTIES;

Dependencies

[top of page]

SYS.DATABASE_PROPERTIES references the following:

SchemaSYS
TablePROPS$
SYS.DATABASE_PROPERTIES is referenced by following:

SchemaPUBLIC
SynonymDATABASE_PROPERTIES
SchemaSYS
Package BodyAD_ZD_SYS - show dependent code
Package BodyDBMS_DST - show dependent code
ViewUSABLE_EDITIONS