dba_streams_rules

RULE_NAME         Current Rule Condition
---------------- -----------------------------------
RULE$_7          :"VAR$_6".JOB_NAME IS NOT NULL
RULE$_11         :"VAR$_10".JOB_NAME IS NOT NULL
RULE$_3          :"VAR$_2".GET_FLAGS() IS NOT NULL
LN4_RULE1_DML    :dml.get_object_owner () = 'NY4' AND
                 :dml.is_null_tag() = 'Y'

Another interesting piece of information that can be obtained is any modification made to the rule condition. The following query displays the rule name, the original rule condition, and the current rule condition for each Streams rule whose condition has been modified:

COLUMN RULE_NAME HEADING 'Rule Name' FORMAT A12
COLUMN ORIGINAL_RULE_CONDITION HEAD 'Original Rule Condi' FORMAT A35
COLUMN RULE_CONDITION HEADING 'Current Rule Condition' FORMAT A33

SET LONG 10000
SELECT RULE_NAME, ORIGINAL_RULE_CONDITION, RULE_CONDITION
FROM DBA_STREAMS_RULES
SEE CODE DEPOT FOR FULL SCRIPT
/

Note: The query in this section applies only to Streams rules. It does not apply to rules created using the dbms_rule_adm package because these rules always show NULL for the ORIGINAL_RULE_CONDITION column and NULL for the SAME_RULE_CONDITION column.