Oracle教程 2023-02-23

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

_VW

ALL_HIER_CLASS_AE_VW视图包含主数据(Master Data)中的所有层级定义和属性定义，可以帮助用户构建层级属性框架。

主数据(Master Data)是描述企业组织、产品、客户等业务要素的数据，是组织中最核心、基础的数据资源。

ALL_HIER_CLASS_AE_VW视图可以查看每个主数据属性定义和层级之间的层级关系，例如层级ID，上级层级ID，层级名称，层级级别，以及属性的定义和计量单位等信息。

使用ALL_HIER_CLASS_AE_VW视图的方法非常简单，在SQL查询中引用 ALL_HIER_CLASS_AE_VW 视图即可。

ALL_HIER_CLASS_AE describes the classifications of the hierarchies (across all editions) accessible to the current user.

Related Views

DBA_HIER_CLASS_AE describes the classifications of all hierarchies (across all editions) in the database.
USER_HIER_CLASS_AE describes the classifications of the hierarchies (across all editions) 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
`HIER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the hierarchy
`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).
`EDITION_NAME`	`VARCHAR2(128)`		Name of the application edition where the hierarchy is defined

Note:

This view is available starting with Oracle Database release 21c, version 21.5.