SELECT rule_set_owner, rule_set_name, NULL,
decode(rule_set_eval_context_owner, NULL, NULL,
rule_set_eval_context_owner||'.'||rule_set_eval_context_name),
rule_set_comment
FROM dba_rule_sets
SELECT RULE_SET_OWNER
, RULE_SET_NAME
, NULL
,
DECODE(RULE_SET_EVAL_CONTEXT_OWNER
, NULL
, NULL
,
RULE_SET_EVAL_CONTEXT_OWNER||'.'||RULE_SET_EVAL_CONTEXT_NAME)
,
RULE_SET_COMMENT
FROM DBA_RULE_SETS
|
|
|