1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_RULES

3.34 ALL_RULES

ALL_RULES describes the rules accessible to the current user.

Related Views

  • DBA_RULES describes all rules in the database.

  • USER_RULES describes the rules owned by the current user. This view does not display the RULE_OWNER column.

Column Datatype NULL Description

RULE_OWNER

VARCHAR2(128)

NOT NULL

Owner of the rule

RULE_NAME

VARCHAR2(128)

NOT NULL

Name of the rule

RULE_CONDITION

CLOB

Expressions and operators that constitute the rule condition

RULE_EVALUATION_CONTEXT_OWNER

VARCHAR2(128)

Owner of the evaluation context associated with the rule, if any

RULE_EVALUATION_CONTEXT_NAME

VARCHAR2(128)

Name of the evaluation context associated with the rule, if any

RULE_ACTION_CONTEXT

RE$NV_LIST

Action context associated with the rule, if any

RULE_COMMENT

VARCHAR2(4000)

Comment specified with the rule, if any

See Also: