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_AGGREGATESdescribes all such grouping functions defined for all materialized views in the database. -
USER_MVIEW_AGGREGATESdescribes 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(*). |
See Also: