VIEW: SYS._DBA_STREAMS_RULES_H

Source

View Text - Preformatted

select sp.streams_type, sp.streams_name, sp.rule_set_type,
       sp.rule_set_owner, sp.rule_set_name,
       ru.name rule_owner, ro.name rule_name,
       r.condition
  from "_DBA_STREAMS_PROCESSES" sp, obj$ rso, user$ rsu,
       rule$ r, obj$ ro, user$ ru, rule_map$ rm
  where sp.rule_set_owner = rsu.name
    and sp.rule_set_name = rso.name
    and rso.owner# = rsu.user#
    and rso.obj# = rm.rs_obj#
    and r.obj# = rm.r_obj#
    and ro.obj# = rm.r_obj#
    and ru.user# = ro.owner#

View Text - HTML Formatted

SELECT SP.STREAMS_TYPE
, SP.STREAMS_NAME
, SP.RULE_SET_TYPE
, SP.RULE_SET_OWNER
, SP.RULE_SET_NAME
, RU.NAME RULE_OWNER
, RO.NAME RULE_NAME
, R.CONDITION
FROM "_DBA_STREAMS_PROCESSES" SP
, OBJ$ RSO
, USER$ RSU
, RULE$ R
, OBJ$ RO
, USER$ RU
, RULE_MAP$ RM
WHERE SP.RULE_SET_OWNER = RSU.NAME
AND SP.RULE_SET_NAME = RSO.NAME
AND RSO.OWNER# = RSU.USER#
AND RSO.OBJ# = RM.RS_OBJ#
AND R.OBJ# = RM.R_OBJ#
AND RO.OBJ# = RM.R_OBJ#
AND RU.USER# = RO.OWNER#