DBA Data[Home] [Help]
Skip to content

VIEW: SYS.GV_$RULE

Source

View Text - Preformatted

select "INST_ID","RULE_SET_OBJECT_ID","EVALUATION_CONTEXT_OBJECT_ID","RULE_OWNER","RULE_NAME","RULE_CONDITION","TRUE_HITS","MAYBE_HITS","SQL_EVALUATIONS","CON_ID" from gv$rule
View Text - HTML Formatted

SELECT "INST_ID"
, "RULE_SET_OBJECT_ID"
, "EVALUATION_CONTEXT_OBJECT_ID"
, "RULE_OWNER"
, "RULE_NAME"
, "RULE_CONDITION"
, "TRUE_HITS"
, "MAYBE_HITS"
, "SQL_EVALUATIONS"
, "CON_ID"
FROM GV$RULE