VIEW: SYS._DBA_STREAMS_RULES_H2

Source

View Text - Preformatted

select decode(r.streams_type, 1, 'CAPTURE',
                              2, 'PROPAGATION',
                              3, 'APPLY',
                              4, 'DEQUEUE',
                              5, 'SYNC_CAPTURE') streams_type,
       r.streams_name, r.rule_set_owner, r.rule_set_name,
       r.rule_owner, r.rule_name, r.rule_condition, r.rule_set_type,
       decode(sr.object_type, 1, 'TABLE',
                              2, 'SCHEMA',
                              3, 'GLOBAL',
                              4, 'PROCEDURE') streams_rule_type,
       sr.schema_name, sr.object_name,
       decode(sr.subsetting_operation, 1, 'INSERT',
                                       2, 'UPDATE',
                                       3, 'DELETE') subsetting_operation,
       sr.dml_condition,
       decode(sr.include_tagged_lcr, 0, 'NO',
                                     1, 'YES') include_tagged_lcr,
       sr.source_database,
       decode(sr.rule_type, 1, 'DML',
                            2, 'DDL',
                            3, 'PROCEDURE') rule_type,
       sr.rule_condition original_rule_condition,
       decode(sr.rule_condition,
              NULL, NULL,
              dbms_lob.substr(r.rule_condition), 'YES',
              decode(least(4001,dbms_lob.getlength(r.rule_condition)),
                     4001, NULL, 'NO')) same_rule_condition,
       sr.source_root_name
  from "_DBA_STREAMS_RULES_H" r, streams$_rules sr
  where r.rule_name = sr.rule_name(+)
    and r.rule_owner = sr.rule_owner(+)

View Text - HTML Formatted

SELECT DECODE(R.STREAMS_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION'
, 3
, 'APPLY'
, 4
, 'DEQUEUE'
, 5
, 'SYNC_CAPTURE') STREAMS_TYPE
, R.STREAMS_NAME
, R.RULE_SET_OWNER
, R.RULE_SET_NAME
, R.RULE_OWNER
, R.RULE_NAME
, R.RULE_CONDITION
, R.RULE_SET_TYPE
, DECODE(SR.OBJECT_TYPE
, 1
, 'TABLE'
, 2
, 'SCHEMA'
, 3
, 'GLOBAL'
, 4
, 'PROCEDURE') STREAMS_RULE_TYPE
, SR.SCHEMA_NAME
, SR.OBJECT_NAME
, DECODE(SR.SUBSETTING_OPERATION
, 1
, 'INSERT'
, 2
, 'UPDATE'
, 3
, 'DELETE') SUBSETTING_OPERATION
, SR.DML_CONDITION
, DECODE(SR.INCLUDE_TAGGED_LCR
, 0
, 'NO'
, 1
, 'YES') INCLUDE_TAGGED_LCR
, SR.SOURCE_DATABASE
, DECODE(SR.RULE_TYPE
, 1
, 'DML'
, 2
, 'DDL'
, 3
, 'PROCEDURE') RULE_TYPE
, SR.RULE_CONDITION ORIGINAL_RULE_CONDITION
, DECODE(SR.RULE_CONDITION
, NULL
, NULL
, DBMS_LOB.SUBSTR(R.RULE_CONDITION)
, 'YES'
, DECODE(LEAST(4001
, DBMS_LOB.GETLENGTH(R.RULE_CONDITION))
, 4001
, NULL
, 'NO')) SAME_RULE_CONDITION
, SR.SOURCE_ROOT_NAME
FROM "_DBA_STREAMS_RULES_H" R
, STREAMS$_RULES SR
WHERE R.RULE_NAME = SR.RULE_NAME(+)
AND R.RULE_OWNER = SR.RULE_OWNER(+)