Oracle教程 2023-02-25

Oracle 视图 ALL_MVIEW_AGGREGATES 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_MVIEW_AGGREGATES包含有关当前用户的所有materialized views的信息，包括累加器的列名、累加器的类型等。

使用方法：

1.查询某个materialized view的累加器列名和类型:
SELECT mview_name, aggregate_column, aggregate_datatype
FROM all_mview_aggregates
WHERE mview_name = ”;

2.查询全部materialized view的累加器列名和类型：
SELECT mview_name, aggregate_column, aggregate_datatype
FROM all_mview_aggregates;

官方英文解释

ALL_MVIEW_AGGREGATES describes the grouping functions (aggregate operations) that appear in the SELECT list of materialized aggregate views accessible to the current user.

Related Views

DBA_MVIEW_AGGREGATES describes all such grouping functions defined for all materialized views in the database.
USER_MVIEW_AGGREGATES describes all such grouping functions defined for all materialized views owned by the current user.

Note:

All three views exclude materialized views that reference remote tables or that include references to a nonstatic value such as SYSDATE or USER. These views also exclude materialized views that were created as “snapshots” before Oracle8i and that were never altered to enable query rewrite.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the materialized view
`MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the materialized view
`POSITION_IN_SELECT`	`NUMBER`	`NOT NULL`	Ordinal position of this aggregation within the `SELECT` list. For the position of nonaggregate elements of the select list, see “ALL_MVIEW_KEYS”.
`CONTAINER_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Name of this column in the container table
`AGG_FUNCTION`	`VARCHAR2(8)`		Aggregation function
`DISTINCTFLAG`	`VARCHAR2(1)`		Indicates whether this aggregation is distinct (`Y`) or not (`N`)
`MEASURE`	`LONG`		SQL text of the measure, excluding the aggregation function. Equal to `` for `COUNT()`.

本站中文解释

官方英文解释

相关推荐