Table: ALL_MVIEW_AGGREGATES
Description of the materialized view aggregates accessible to the user
Column Name | Description |
---|---|
AGG_FUNCTION | Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV |
CONTAINER_COLUMN | Name of this column in the container table |
DISTINCTFLAG | Set to Y is this is a DISTINCT aggregation |
MEASURE | The SQL text of the measure, excluding the aggregation function |
MVIEW_NAME | Name of the materialized view |
OWNER | Owner of the materialized view |
POSITION_IN_SELECT | Position of this aggregated measure with the SELECT list |