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

VIEW: SYS.CDB_ZONEMAP_MEASURES

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

All zonemap measures in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Zonemap owner name
ZONEMAP_NAME VARCHAR2 (128) Yes Zonemap name
POSITION_IN_SELECT NUMBER

Ordinal position of measure aggregate
AGG_FUNCTION VARCHAR2 (13)
Type of aggregate function: MIN/MAX
AGG_COLUMN_NAME VARCHAR2 (128)
Aggregate column name in zonemap table
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      ZONEMAP_NAME
,      POSITION_IN_SELECT
,      AGG_FUNCTION
,      AGG_COLUMN_NAME
,      CON_ID
FROM SYS.CDB_ZONEMAP_MEASURES;

Dependencies

[top of page]

SYS.CDB_ZONEMAP_MEASURES does not reference any database object

SYS.CDB_ZONEMAP_MEASURES is referenced by following:

SchemaPUBLIC
SynonymCDB_ZONEMAP_MEASURES