ALL_MVIEW_AGGREGATES

Description of the materialized view aggregates accessible to the user

Columns
   ___________________________
 
   OWNER
      Owner of the materialized view
   MEASURE
      The SQL text of the measure, excluding the aggregation function
   DISTINCTFLAG
      Set to Y is this is a DISTINCT aggregation
   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
   POSITION_IN_SELECT
      Position of this aggregated measure with the SELECT list
   MVIEW_NAME
      Name of the materialized view

Related Commands:

Simon Sheppard
SS64.com