Oracle教程 2023-02-26

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

ALL_ANALYTIC_VIEW_HIERS视图提供有关使用Oracle分析加载据中止汇总等内容的内容，每行表示一个数据集或汇总表或报告，以及它们之间的此关系。此视图接受两个参数：

1. owner_name：要检索视图行的数据集所有者的名称。

2. dataset_name：要检索的视图行的数据集的名称。

要使用该视图，请在查询中指定视图中的以下字段： OWNER_NAME、DATASET_NAME、PARENT_TYPE、PARENT_NAME、HIER_TYPE、HIER_NAME：

SELECT OWNER_NAME, DATASET_NAME, PARENT_TYPE, PARENT_NAME, HIER_TYPE, HIER_NAME
FROM ALL_ANALYTIC_VIEW_HIERS
WHERE OWNER_NAME = AND DATASET_NAME = ;

ALL_ANALYTIC_VIEW_HIERS describes the hierarchies in the analytic views accessible to the current user.

Related Views

DBA_ANALYTIC_VIEW_HIERS describes the hierarchies in all analytic views in the database.
USER_ANALYTIC_VIEW_HIERS describes the hierarchies 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 the analytic view hierarchy
`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
`HIER_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the hierarchy
`HIER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the hierarchy
`HIER_ALIAS`	`VARCHAR2(128)`		Alias specified for the hierarchy
`IS_DEFAULT`	`VARCHAR2(1)`		Indicates whether this is the default hierarchy for the analytic view dimension in the analytic view (`Y`) or not (`N`)
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the hierarchy in the list of hierarchies 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).