VIEW: SYS.DBA_RULE_SET_RULES

Source

View Text - Preformatted

SELECT /*+ all_rows */
       u.name, o.name, ru.name, ro.name,
       decode(bitand(rm.property, 1), 1, 'DISABLED', 'ENABLED'),
       eu.name, eo.name, rm.rm_comment
FROM   rule_map$ rm, obj$ o, user$ u, obj$ ro, user$ ru, obj$ eo, user$ eu
WHERE  rm.rs_obj# = o.obj# and o.owner# = u.user# and rm.r_obj# = ro.obj# and
       ro.owner# = ru.user# and rm.ectx# = eo.obj#(+) and
       eo.owner# = eu.user#(+)

View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ U.NAME
, O.NAME
, RU.NAME
, RO.NAME
, DECODE(BITAND(RM.PROPERTY
, 1)
, 1
, 'DISABLED'
, 'ENABLED')
, EU.NAME
, EO.NAME
, RM.RM_COMMENT FROM RULE_MAP$ RM
, OBJ$ O
, USER$ U
, OBJ$ RO
, USER$ RU
, OBJ$ EO
, USER$ EU WHERE RM.RS_OBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND RM.R_OBJ# = RO.OBJ# AND RO.OWNER# = RU.USER#
AND RM.ECTX# = EO.OBJ#(+) AND EO.OWNER# = EU.USER#(+)