Oracle 视图 ALL_ANALYTIC_VIEW_DIM_ATRS_AE 官方解释，作用，如何使用详细说明
本站中文解释
ALL_ANALYTIC_VIEW_DIM_ATRS_AE是Oracle中的一种视图，用于提供有关Analytic View中定义维度和属性的详细信息。搜索此视图，将可提供以下细节：
– 每个维度的表和源列。
– 维度特征列的定义列表，比如属性痕迹、最小值和最大值。
– 每个属性名称以及属性包含来自哪个列
– 每个维度中可以使用多少属性
– 每个维度和属性排序类型
– 每个维度和属性数据类型
要使用ALL_ANALYTIC_VIEW_DIM_ATRS_AE视图，您可以执行带有where子句的查询，以缩小维护的具体范围。例如，要检索Analytic View中只有日期维度的定义，可以使用以下语句：
SELECT * FROM all_analytic_view_dim_atrs_ae WHERE analytic_view_name = MyView AND dimension_name = ‘Date’;
官方英文解释
ALL_ANALYTIC_VIEW_DIM_ATRS_AE describes the attributes of the attribute dimensions in the analytic views (across all editions) accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_DIM_ATRS_AEdescribes the attributes of the attribute dimensions in all analytic views (across all editions) in the database. -
USER_ANALYTIC_VIEW_DIM_ATRS_AEdescribes the attributes of the attribute dimensions in the analytic views (across all editions) owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the analytic view |
|
|
|
|
Name of the analytic view |
|
|
|
|
Alias of the attribute dimension in the analytic view |
|
|
|
NOT NULL |
The name of the attribute within the analytic view |
|
|
|
|
Alias of the source table for the attribute |
|
|
|
NOT NULL |
Name of the column |
|
|
|
NOT NULL |
Order of the attribute as defined in the metadata |
|
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
Name of the application edition where the analytic view is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_ANALYTIC_VIEW_DIM_ATRS_AE”
-
“USER_ANALYTIC_VIEW_DIM_ATRS_AE”
