[Home] [Help] [Dependency Information]
Object Name: | USER_METADATA_PROPERTIES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP Metadata Properties owned by the user in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNING_OBJECT_ID | NUMBER | Yes | Dictionary Id of the OLAP Metadata Property owner | |
OWNING_TYPE | VARCHAR2 | (23) | Owning type of the OLAP Metadata Property | |
PROPERTY_ID | NUMBER | Yes | Dictionary Id of the OLAP Metadata Property | |
PROPERTY_KEY | VARCHAR2 | (30) | Yes | Key of the OLAP Metadata Property |
PROPERTY_VALUE | CLOB | (4000) | Value of the OLAP Metadata Property | |
PROPERTY_ORDER | NUMBER | Yes | Order number of the OLAP Metadata Property |
Cut, paste (and edit) the following text to query this object:
SELECT OWNING_OBJECT_ID
, OWNING_TYPE
, PROPERTY_ID
, PROPERTY_KEY
, PROPERTY_VALUE
, PROPERTY_ORDER
FROM SYS.USER_METADATA_PROPERTIES;
|
|
|