Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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


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" prior to Oracle8i and that were never altered to enable query rewrite.
Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the materialized view
MVIEW_NAME VARCHAR2(30) 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(30) 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(*).