eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.ALL_ZONEMAP_MEASURES

Object Details

Object Name:	ALL_ZONEMAP_MEASURES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Zonemap measures accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Zonemap owner name
ZONEMAP_NAME	VARCHAR2	(128)	Yes	Zonemap name
MEASURE	LONG	(0)		Column whose MIN/MAX materialized
POSITION_IN_SELECT	NUMBER		Yes	Ordinal position of measure aggregate
AGG_FUNCTION	VARCHAR2	(13)		Type of aggregate function: MIN/MAX
AGG_COLUMN_NAME	VARCHAR2	(128)	Yes	Aggregate column name in zonemap table

Query Text

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


SELECT OWNER
,      ZONEMAP_NAME
,      MEASURE
,      POSITION_IN_SELECT
,      AGG_FUNCTION
,      AGG_COLUMN_NAME
FROM SYS.ALL_ZONEMAP_MEASURES;

Dependencies

[top of page]

SYS.ALL_ZONEMAP_MEASURES references the following:

SYS: DBA_ZONEMAP_MEASURES; OBJ$; OBJAUTH$; USER$

SYS.ALL_ZONEMAP_MEASURES is referenced by following:

PUBLIC: ALL_ZONEMAP_MEASURES