Oracle教程 2023-04-03

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

本站中文解释

Oracle 视图 ALL_MVIEW_KEYS 是一个字典视图，用于存储关于每个可重复更新的数据库视图的成员查询的键列的信息。

该视图中存储的列名称，例如 MVIEW_NAME、MV_OWNER、COL_NAME 等，每列对应于视图语句中 SELECT 子句中的位置和顺序，并按表示一个数据库视图。它还为每个数据库视图提供了一个可重复更新视图主键，并列出了可重复更新视图主键中的每个字段。

使用 ALL_MVIEW_KEYS 视图可以识别出由可重复更新的数据库视图及其成员查询提供的数据库视图的哪些字段为主键。针对使用 ALL_MVIEW_KEYS 视图可以使用 SELECT 语句来检索主键列的信息，例如：

SELECT mview_name, mv_owner, col_name FROM all_MVIEW_KEYS;

官方英文解释

ALL_MVIEW_KEYS describes the columns or expressions in the SELECT list upon which materialized views accessible to the current user are based.

Related Views

DBA_MVIEW_KEYS describes such columns and expressions for all materialized views in the database.
USER_MVIEW_KEYS describes such columns and expressions for all materialized views owned by the current user.

Note:

All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as SYSDATE or USER. These views also exclude materialized views that were created as snapshots before Oracle8i and that were never altered to enable query rewrite.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the materialized view
`MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Materialized view name
`POSITION_IN_SELECT`	`NUMBER`	`NOT NULL`	Ordinal position of this key within the `SELECT` list
`CONTAINER_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Name of the column in the container table
`DETAILOBJ_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Detail object owner
`DETAILOBJ_NAME`	`VARCHAR2(128)`	`NOT NULL`	Detail object name (for example, the name of a table or view)
`DETAILOBJ_ALIAS`	`VARCHAR2(128)`		Implicit or explicit alias for detail relation
`DETAILOBJ_TYPE`	`VARCHAR2(5)`		Detail object type: `TABLE` `VIEW`
`DETAILOBJ_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Name of the detail relation column

本站中文解释

官方英文解释

相关推荐