Oracle 视图 ALL_ATTRIBUTE_DIM_CLASS_AE 官方解释，作用，如何使用详细说明
本站中文解释
ALL_ATTRIBUTE_DIM_CLASS_AE视图显示的是分析引擎（Analytic Engine，AE）中定义的查询维度的属性，其中包含每个查询维度的名称，类型，标签和描述。Oracle创建此视图，以帮助AE用户进行查询分析和报表制作，并为用户提供关于每个查询维度的更多信息，以及用于识别其各自特点和功能的有用信息。
ALL_ATTRIBUTE_DIM_CLASS_AE视图可以使用SELECT语句来读取数据，可以选择仅返回某些行。例如，可以使用SELECT语句来显示具有指定类型的特定维度的名称，例如：
SELECT DIMENSION_NAME FROM ALL_ATTRIBUTE_DIM_CLASS_AE WHERE DIMENSION_TYPE = ‘PROVINCE’;
上述SELECT语句将仅返回具有指定类型（“PROVINCE”）的维度的名称，这样用户将有更好的把了解每个维度的概念。此外，用户还可以利用ALL_ATTRIBUTE_DIM_CLASS_AE视图检索特定维度的标签和描述，并获取存储在特定维度内的数据。
官方英文解释
ALL_ATTRIBUTE_DIM_CLASS_AE describes the classifications of the attribute dimensions (across all editions) accessible to the current user.
Related Views
-
DBA_ATTRIBUTE_DIM_CLASS_AEdescribes the classifications of all attribute dimensions (across all editions) in the database. -
USER_ATTRIBUTE_DIM_CLASS_AEdescribes the 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 |
|
|
|
Classification associated with the attribute dimension |
|
|
|
|
Value of the classification, or NULL if not specified | |
|
|
|
NLS_LANGUAGE value associated with the classification, or NULL if not specified
|
|
|
|
|
|
Order of the classification in the list of classifications associated with the attribute dimension |
|
|
|
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_CLASS_AE”
-
“USER_ATTRIBUTE_DIM_CLASS_AE”
