Oracle 视图 ALL_ATTRIBUTE_DIM_ATTR_CLS_AE 官方解释，作用，如何使用详细说明
本站中文解释
All_ATTRIBUTE_DIM_ATTR_CLS_AE是Oracle提供的一个系统视图，其涉及到的表包括M_ATTRIBUTEDIMENSION表和M_ATTRIBUTE_IN_VALUE_SETS表。它可以用于查询指定维度名下属性类型、属性、属性值分类和属性值集的相关信息。
语法格式：
SELECT * FROM all_attribute_dim_att_cls_ae WHERE ATTRIBUTE_DIM_NAME = {维度名};
使用示例：
SELECT * FROM all_attribute_dim_att_cls_ae WHERE ATTRIBUTE_DIM_NAME = ‘COUNTRY’;
该查询可以查出所有属于COUNTRY维度的属性类型、属性、属性值分类和属性值集的相关信息。
官方英文解释
ALL_ATTRIBUTE_DIM_ATTR_CLS_AE describes the attribute classifications of the attribute dimensions (across all editions) accessible to the current user.
Related Views
-
DBA_ATTRIBUTE_DIM_ATTR_CLS_AEdescribes the attribute classifications of all attribute dimensions (across all editions) in the database. -
USER_ATTRIBUTE_DIM_ATTR_CLS_AEdescribes the attribute classifications of the attribute dimensions (across all editions) owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the attribute dimension |
|
|
|
|
Name of the attribute dimension |
|
|
|
Name of the attribute |
|
|
|
|
Classification associated with the attribute |
|
|
|
|
Value of the classification, or NULL if not specified |
|
|
|
|
|
|
|
|
|
|
Order of the classification in the list of classifications associated with the attribute |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
|
Name of the application edition where the attribute dimension is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_ATTRIBUTE_DIM_ATTR_CLS_AE”
-
“USER_ATTRIBUTE_DIM_ATTR_CLS_AE”
