VIEW: SYS.USER_ZONEMAP_MEASURES

Source

View Text - Preformatted

select z."OWNER",z."ZONEMAP_NAME",z."MEASURE",z."POSITION_IN_SELECT",z."AGG_FUNCTION",z."AGG_COLUMN_NAME" from dba_zonemap_measures z, sys.user$ u
where u.user# = userenv('SCHEMAID')
  and z.owner = u.name

View Text - HTML Formatted

SELECT Z."OWNER"
, Z."ZONEMAP_NAME"
, Z."MEASURE"
, Z."POSITION_IN_SELECT"
, Z."AGG_FUNCTION"
, Z."AGG_COLUMN_NAME"
FROM DBA_ZONEMAP_MEASURES Z
, SYS.USER$ U WHERE U.USER# = USERENV('SCHEMAID')
AND Z.OWNER = U.NAME