DBA_MVIEW_AGGREGATES

Description of the materialized view aggregates accessible to dba

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

Related:


© Copyright SS64.com 1999-2014
Some rights reserved