Oracle教程 2023-02-23

Oracle 视图 ALL_RULE_SET_RULES 官方解释，作用，如何使用详细说明

Oracle视图ALL_RULE_SET_RULES用于提供一个用户可以访问到当前实例中规则集中的所有规则的信息。

它包含每个规则的元数据，如参数类型、SQL定义以及规则集中其他信息。它用于管理Oracle规则引擎数据库对象的完整性、可验证和一致性等。

要使用ALL_RULE_SET_RULES视图，必须指定规则集的名字、状态说明或者规则的名字和版本等。例如，要获得规则集Test_Rules中规则的元数据，可以执行以下查询：

SELECT *
FROM all_rule_set_rules
WHERE rule_set_name = ‘Test_Rules’;

ALL_RULE_SET_RULES describes the rules in the rule sets accessible to the current user.

Related Views

DBA_RULE_SET_RULES describes the rules in all rule sets in the database.
USER_RULE_SET_RULES describes the rules in the rule sets owned by the current user. This view does not display the RULE_SET_OWNER column.

Column	Datatype	NULL	Description
`RULE_SET_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the rule set
`RULE_SET_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the rule set
`RULE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the rule
`RULE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the rule
`RULE_SET_RULE_ENABLED`	`VARCHAR2(8)`		Indicates whether the rule is enabled in the rule set (`ENABLED`) or not (`DISABLED`)
`RULE_SET_RULE_EVAL_CTX_OWNER`	`VARCHAR2(128)`		Owner of the evaluation context specified when the rule was added to the rule set, if any
`RULE_SET_RULE_EVAL_CTX_NAME`	`VARCHAR2(128)`		Name of the evaluation context specified when the rule was added to the rule set, if any
`RULE_SET_RULE_COMMENT`	`VARCHAR2(4000)`		Comment specified when the rule was added to the rule set, if any