Oracle 视图 ALL_HIERARCHIES_AE 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图ALL_HIERARCHIES_AE是Oracle数据挖掘扩展功能中的内部视图,显示了用户具有查看权限的所有层次结构和IDに関連付けられた层次结构属性。
用途:通过ALL_HIERARCHIES_AE视图,用户可以获取到存储在层次结构和层次结构属性表中的字段信息,便于分析统计不同的层级关系,以及每个层级下的属性值。
使用方法:使用ALL_HIERARCHIES_AE视图的最常见的查询方式是使用“SELECT * FROM all_hierarchies_ae”语句来获取所有层次结构和层次结构属性。
官方英文解释
ALL_HIERARCHIES_AE
describes the hierarchies (across all editions) accessible to the current user.
Related Views
-
DBA_HIERARCHIES_AE
describes all hierarchies (across all editions) in the database. -
USER_HIERARCHIES_AE
describes the hierarchies (across all editions) owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the hierarchy |
|
|
|
Name of the hierarchy |
|
|
|
Owner of the attribute dimension used by the hierarchy |
|
|
|
Name of the attribute dimension used by the hierarchy |
|
|
The value of this column is always NULL |
|
|
|
Compile status of the hierarchy:
|
|
|
|
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_HIERARCHIES_AE”
-
“USER_HIERARCHIES_AE”