Oracle教程 2023-04-06

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

ALL_RULE_SETS视图保存有关Oracle数据知识库（RULESETS）的信息视图。用法如下：

1.查询所有规则集的名称：

SELECT RULESET_NAME FROM ALL_RULE_SETS;

2.查询指定规则集的信息：

SELECT * FROM ALL_RULE_SETS WHERE RULESET_NAME=”;

3.查询指定规则集的参数：

SELECT * FROM ALL_RULE_SET_PARAMS WHERE RULESET_NAME=”;

ALL_RULE_SETS describes the rule sets accessible to the current user.

Related Views

DBA_RULE_SETS describes all rule sets in the database.
USER_RULE_SETS describes 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_SET_EVAL_CONTEXT_OWNER`	`VARCHAR2(128)`		Owner of the evaluation context associated with the rule set, if any
`RULE_SET_EVAL_CONTEXT_NAME`	`VARCHAR2(128)`		Name of the evaluation context associated with the rule set, if any
`RULE_SET_COMMENT`	`VARCHAR2(4000)`		Comment specified with the rule set, if any