Oracle教程 2023-02-23

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

_VIEWS:
Classify: SELECT & JOIN分类

Oracle视图：ALL_OPENCILLARY_VIEWS

用途：它是一种特殊类型的视图，对应着Oracle数据库中的ALL_OPENCILLARY_COLUMNS表，用于检索与特定表相关的列的描述和约束信息。

使用方法：1. 首先需要获取表的名称，我们可以使用ALL_TABLES视图；
2. 使用ALL_OPENCILLARY_VIEWS视图查询仅提供表名的记录；
3. 返回的结果就是特定表的列的描述和约束信息；
4. 最后根据需要对查询出来的记录进行选择和筛选，获取你感兴趣的信息。

ALL_OPANCILLARY describes operators whose bindings are ancillary to other (primary) operators.

Related Views

DBA_OPANCILLARY describes such information about all operators in the database.
USER_OPANCILLARY describes such information about operators owned by the current user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the ancillary operator
`OPERATOR_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the ancillary operator
`BINDING#`	`NUMBER`	`NOT NULL`	Binding number of the ancillary operator
`PRIMOP_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the primary operator
`PRIMOP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the primary operator
`PRIMOP_BIND#`	`NUMBER`	`NOT NULL`	Binding number of the primary operator