| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
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
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.
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) |
Whether this aggregation is distinct (Y | N) |
|
MEASURE |
LONG |
SQL text of the measure, excluding the aggregation function. Equal to * for COUNT(*). |
