Oracle教程 2023-02-23

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

Oracle视图ALL_HIER_LEVELS（全部Hierarchy级别）存储系统中的所有层次级别，它的内容可以用来检索和操作系统中的所有层次结构和系统维护层次结构。

该视图由下列列组成：

HIER_ID：层次结构ID
LEVEL_NUM：层次结构级别，从1到4
LEVEL_NAME：级别名称
LEVEL_ATTR：级别属性

要查看系统中所有的hierarchy级别，可以运行下面的查询：

SELECT * FROM ALL_HIER_LEVELS;

要查找具有某个特定属性的HIER，可以使用下面的查询：

SELECT * FROM ALL_HIER_LEVELS WHERE LEVEL_ATTR=’myAttr’;

ALL_HIER_LEVELS describes the levels of the hierarchies accessible to the current user.

Related Views

DBA_HIER_LEVELS describes the levels of all hierarchies in the database.
USER_HIER_LEVELS describes the levels of the hierarchies 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
`LEVEL_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of hierarchy level
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the level in the list of hierarchy levels
`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).