Oracle教程 2023-02-23

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

ALL_ANALYTIC_VIEW_HIER_CLASSES是Oracle数据库提供的一个系统视图，它包含了拥有 analytic viewpoint 所需的层次分类 of hierarchical view. 它会显示层次视图的父类，子类，class_id 和Base 的列.

通过使用 ALL_ANALYTIC_VIEW_HIER_CLASSES 视图，我们可以查询层次视图的内容，获取和修改视图的名称和编号，可以介入到Oracle 仓库管理系统中.

例如，我们可以使用以下查询：

SELECT * FROM ALL_ANALYTIC_VIEW_HIER_CLASSES;

这会显示层次视图的父类，子类，class_id 和 Base 的列.

另外，我们还可以使用以下查询更新层次视图的名称：

UPDATE ALL_ANALYTIC_VIEW_HIER_CLASSES SET CLASS_NAME = ‘New Name’ WHERE CLASS_ID = ‘001’;

这样就可以更新指定的层次视图的名称.

ALL_ANALYTIC_VIEW_HIER_CLASS describes the classifications of the hierarchies in the analytic views accessible to the current user.

Related Views

DBA_ANALYTIC_VIEW_HIER_CLASS describes the classifications of the hierarchies in all analytic views in the database.
USER_ANALYTIC_VIEW_HIER_CLASS describes the classifications of 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 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_ALIAS`	`VARCHAR2(128)`		Alias of the hierarchy in the attribute dimension in the analytic view
`CLASSIFICATION`	`VARCHAR2(128)`		Classification associated with the hierarchy
`VALUE`	`CLOB`		Value of the classification, or NULL if not specified
`LANGUAGE`	`VARCHAR2(64)`		`NLS_LANGUAGE` value associated with the classification, or NULL if not specified
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the classification in the list of classifications associated with the hierarchy
`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).