Oracle 视图 ALL_HIER_HIER_ATTR_CLASS_AE 官方解释，作用，如何使用详细说明
本站中文解释
ALL_HIER_HIER_ATTR_CLASS_AE视图是Oracle数据字典视图，显示系统中所有的层级属性集的属性类的定义和信息。
这个视图包含如下列：
ATTR_CLASS：定义属性类的名称。
HIER_ID：描述这个层级属性集的标识符。
HIER_NAME：层级属性集的名称。
HIER_ORDER：属性类的显示顺序。
这个视图可以用于检索一些有用的信息，比如层级属性集的属性信息。我们可以使用它来确定属性是否在层级属性集类中。
例如，我们可以使用该视图来查找在层级属性集名为employee的类中的属性。
SELECT *
FROM ALL_HIER_HIER_ATTR_CLASS_AE
WHERE HIER_NAME = ‘Employee’;
官方英文解释
ALL_HIER_HIER_ATTR_CLASS_AE describes the classifications of the hierarchical attributes of the hierarchies (across all editions) accessible to the current user.
Related Views
-
DBA_HIER_HIER_ATTR_CLASS_AEdescribes the classifications of the hierarchical attributes of all hierarchies (across all editions) in the database. -
USER_HIER_HIER_ATTR_CLASS_AEdescribes the classifications of the hierarchical attributes of the hierarchies (across all editions) owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the hierarchy |
|
|
|
|
Name of the hierarchy |
|
|
|
Name of the hierarchical attribute |
|
|
|
|
Classification associated with the hierarchical attribute |
|
|
|
|
Value associated with the classification or NULL if not specified |
|
|
|
|
|
|
|
|
|
|
Order of the classification in the list of classifications associated with the hierarchical attribute |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
|
Name of the application edition where the hierarchy is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_HIER_HIER_ATTR_CLASS_AE”
-
“USER_HIER_HIER_ATTR_CLASS_AE”
