Oracle教程 2023-04-02

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

本站中文解释

ALL_HIER_LEVEL_ID_ATTRS_AE（所有层次ID属性视图）视图在Oracle数据库中提供了一种方式，用户可以确定表示层次结构中层次和属性的内部ID。该视图允许用户通过表示层次和属性的字符串值查找其内部ID，也可以通过内部ID获取其字符串表示形式。由于此视图包含了所有的Oracle金蝶企业管理（Ae）层次根据段中的层次和属性，所以它也可以被用做参照表。

使用说明：要使用ALL_HIER_LEVEL_ID_ATTRS_AE视图，只需要在Oracle数据库中执行以下语句：
SELECT * FROM ALL_HIER_LEVEL_ID_ATTRS_AE；
此语句将取出视图中所有层次和属性的内部ID和其相应的字符串表示。

官方英文解释

ALL_HIER_LEVEL_ID_ATTRS_AE describes the attributes that uniquely identify members of the levels of the hierarchies (across all editions) accessible to the current user.

Related Views

DBA_HIER_LEVEL_ID_ATTRS_AE describes the attributes that uniquely identify members of the levels of all hierarchies (across all editions) in the database.
USER_HIER_LEVEL_ID_ATTRS_AE describes the attributes that uniquely identify members of the levels 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
`LEVEL_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of hierarchy level
`ATTRIBUTE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the unique identifier attribute
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the level in the list of unique identifier attributes for the level
`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.

本站中文解释

官方英文解释

相关推荐