Oracle 视图 ALL_ANALYTIC_VIEW_MEAS_CLS_AE 官方解释，作用，如何使用详细说明
本站中文解释
_T
Oracle视图ALL_ANALYTIC_VIEW_MEAS_CLS_AE_T用于显示数据库中所有的分析视图的度量类型的所有属性的信息。它有以下字段：
owner：表示视图的拥有者。
view_name：视图的名称。
column_name：视图中每一列的字段名称。
measure_name：度量名称。
measure_type：度量类型，即计数(COUNT)、和(SUM)、平均值(AVG)等。
measure_all_columns_usage：指定此度量是否应使用视图中的所有列。
使用此视图可以在Oracle数据库中检查每个分析视图中所有度量类型的属性信息。例如，可以查询某一分析视图中所有字段的度量类型：
SELECT owner,view_name,column_name,measure_name,measure_type,measure_all_columns_usage
FROM all_analytic_view_meas_cls_ae_t
WHERE view_name=’MY_ANALYTIC_VIEW’;
官方英文解释
ALL_ANALYTIC_VIEW_MEAS_CLS_AE describes the classifications of the measures of the analytic views (across all editions) accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_MEAS_CLS_AEdescribes the classifications of the measures of all analytic views (across all editions) in the database. -
USER_ANALYTIC_VIEW_MEAS_CLS_AEdescribes the classifications of the measures of 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 |
|
|
|
Name of the measure associated with the classification |
|
|
|
|
Classification associated with the measure of the analytic view |
|
|
|
|
Value of the classification, or NULL if not specified |
|
|
|
|
|
|
|
|
|
|
Order of the classification in the list of classifications associated with the measure |
|
|
|
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_MEAS_CLS_AE”
-
“USER_ANALYTIC_VIEW_MEAS_CLS_AE”
