VIEW: SYS._DBA_RULES1

Source

View Text - Preformatted

select u.name rule_owner, o.name rule_name, r.condition, o.obj#
    from sys.rule$ r, sys.obj$ o, sys.user$ u
    where o.obj# = r.obj# and u.user# = o.owner#

View Text - HTML Formatted

SELECT U.NAME RULE_OWNER
, O.NAME RULE_NAME
, R.CONDITION
, O.OBJ#
FROM SYS.RULE$ R
, SYS.OBJ$ O
, SYS.USER$ U
WHERE O.OBJ# = R.OBJ#
AND U.USER# = O.OWNER#