dba_rule_sets
COLUMN RULE_SET_OWNER HEADING 'Rule
Set|Owner' FORMAT A10
COLUMN RULE_SET_NAME HEADING 'Rule Set
Name' FORMAT A20
COLUMN RULE_SET_EVAL_CONTEXT_OWNER HEADING
'Eval Context|Owner' FORMAT A12
COLUMN RULE_SET_EVAL_CONTEXT_NAME HEADING
'Eval Context Name' FORMAT A30
SELECT RULE_SET_OWNER,
RULE_SET_NAME,
RULE_SET_EVAL_CONTEXT_OWNER,
RULE_SET_EVAL_CONTEXT_NAME
FROM DBA_RULE_SETS
/
dba_rules
This view describes the rules for all
Streams clients in the database.
The RULE_CONDITION column shows the actual
rule in a readable form. The data type of this column is CLOB.
It has the expressions and conditions that make up the rule.
To list each rule in a database that
contains a specified pattern in its condition, the dba_rules
data dictionary view can be queried and the dbma_lob.instr
function used to search for the pattern in the rule conditions.
For example, the following query lists each rule that contains
the pattern ALLINSURED1 in its condition:
COLUMN RULE_OWNER HEADING 'Rule Owner'
FORMAT A30
COLUMN RULE_NAME HEADING 'Rule Name' FORMAT
A30
