Oracle教程 2023-04-03

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

Oracle的视图是使用查询语句选择出的关系表中的行，组成新的表。ALL_ANALYTIC_VIEW_KEYS视图显示系统中所有分析视图的有效关键字。

ALL_ANALYTIC_VIEW_KEYS视图也可以用于查找系统中具有相同名称的分析视图的关键字。该视图显示有效的分析视图中要使用的每个关键字，其中包括独立的列，函数，聚集函数和样式元素。

该视图还可以用于查找已连接到视图的基表列，其中包括在特定分析视图中要使用的基表列的名称、数据类型和长度。

可以使用SQLSELECT语句来访问ALL_ANALYTIC_VIEW_KEYS视图，如下所示：

SELECT *
FROM ALL_ANALYTIC_VIEW_KEYS
WHERE VIEW_NAME = ‘TEST_VIEW’;

上述查询将检索出关于“TEST_VIEW”分析视图中所有关键字的信息。

ALL_ANALYTIC_VIEW_KEYS describes the key columns of the attribute dimensions in the analytic views accessible to the current user.

The keys reference attributes of the attribute dimensions of the analytic view.

Related Views

DBA_ANALYTIC_VIEW_KEYS describes the key columns of the attribute dimensions in all analytic views in the database.
USER_ANALYTIC_VIEW_KEYS describes the key columns of the attribute dimensions in the analytic views owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of analytic view
`ANALYTIC_VIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the analytic view
`DIMENSION_ALIAS`	`VARCHAR2(128)`		Alias of the attribute dimension in the analytic view
`AV_KEY_TABLE_ALIAS`	`VARCHAR2(128)`		Table alias of the key column
`AV_KEY_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Name of the column for the key
`REF_DIMENSION_ATTR`	`VARCHAR2(128)`		Name of the referenced attribute dimension attribute
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order number of the key in the list of keys in the analytic view
`ORIGIN_CON_ID`	`NUMBER`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root).