Oracle 视图 ALL_HIER_LEVEL_ID_ATTRS 官方解释,作用,如何使用详细说明
本站中文解释
ALL_HIER_LEVEL_ID_ATTRS视图是Oracle维度中描述除维度编号及名称外扩展性更广的维度属性。这个视图显示了维度中每一级维度的特定属性,比如是否支持全局唯一性,是否允许为空,是否是有序的,是否可见等。
使用方法:
1.首先,确保用户有访问ALL_HIER_LEVEL_ID_ATTRS的权限;
2.使用查询语句检索维度扩展描述信息,比如:
SELECT *
FROM all_hier_level_id_attrs
WHERE hierarchy_name = ‘product_hier’;
该语句将返回维度中各个级别的属性信息。
官方英文解释
ALL_HIER_LEVEL_ID_ATTRS
describes the attributes that uniquely identify members of the levels of the hierarchies accessible to the current user.
Related Views
-
DBA_HIER_LEVEL_ID_ATTRS
describes the attributes that uniquely identify members of the levels of all hierarchies in the database. -
USER_HIER_LEVEL_ID_ATTRS
describes the attributes that uniquely identify members of the levels of the hierarchies owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the hierarchy |
|
|
|
Name of the hierarchy |
|
|
|
Name of hierarchy level |
|
|
|
Name of the unique identifier attribute |
|
|
|
Order of the level in the list of unique identifier attributes for the level |
|
|
The ID of the container where the data originates. Possible values include:
|
See Also:
-
“DBA_HIER_LEVEL_ID_ATTRS”
-
“USER_HIER_LEVEL_ID_ATTRS”