[Home] [Help] [Dependency Information]
Object Name: | ALL_MVIEW_AGGREGATES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of the materialized view aggregates accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the materialized view |
MVIEW_NAME | VARCHAR2 | (128) | Yes | Name of the materialized view |
POSITION_IN_SELECT | NUMBER | Yes | Position of this aggregated measure with the SELECT list | |
CONTAINER_COLUMN | VARCHAR2 | (128) | Yes | Name of this column in the container table |
AGG_FUNCTION | VARCHAR2 | (8) | Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV | |
DISTINCTFLAG | VARCHAR2 | (1) | Set to Y is this is a DISTINCT aggregation | |
MEASURE | LONG | (0) | The SQL text of the measure, excluding the aggregation function |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, MVIEW_NAME
, POSITION_IN_SELECT
, CONTAINER_COLUMN
, AGG_FUNCTION
, DISTINCTFLAG
, MEASURE
FROM SYS.ALL_MVIEW_AGGREGATES;
|
|
|