Oracle 视图 ALL_ANALYTIC_VIEW_MEAS_CLASS 官方解释，作用，如何使用详细说明
本站中文解释
_ATTR
*ALL_ANALYTIC_VIEW_MEAS_CLASS_ATTR*是Oracle的一种视图，它用于展示描述分析视图上的指标类型（Measure Class）或指标属性（Measure Attribute）信息。ALL_ANALYTIC_VIEW_MEAS_CLASS_ATTR视图提供了一种可以提取这些指标信息的机制，它包含以下字段：
– M_View_Name：视图名称；
– MC_Name：指标类型名称；
– M_Name：指标属性名称；
– M_Description：指标属性描述；
– M_Column_Name：指标属性列名；
使用ALL_ANALYTIC_VIEW_MEAS_CLASS_ATTR视图时，可以根据视图列信息构建SQL语句提取视图上的指标类型及属性的数据，从而达到取出分析视图的指标信息的作用。例如，可以执行如下SQL查询一个视图上的指标属性：
“`
SELECT M_View_Name, MC_Name, M_Name, M_Description, M_Column_Name
FROM ALL_ANALYTIC_VIEW_MEAS_CLASS_ATTR
WHERE M_View_Name=’VIEW_NAME’;
“`
官方英文解释
ALL_ANALYTIC_VIEW_MEAS_CLASS describes the classifications of the measures of the analytic views accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_MEAS_CLASSdescribes the classifications of the measures of all analytic views in the database. -
USER_ANALYTIC_VIEW_MEAS_CLASSdescribes the classifications of the measures of the analytic views 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:
|
See Also:
-
“DBA_ANALYTIC_VIEW_MEAS_CLASS”
-
“USER_ANALYTIC_VIEW_MEAS_CLASS”
