[Home] [Help] [Dependency Information]
Object Name: | CDB_SUMMARY_AGGREGATES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the summary |
SUMMARY_NAME | VARCHAR2 | (30) | Yes | Name of the summary |
POSITION_IN_SELECT | NUMBER | Yes | Position of this aggregated measure with the SELECT list | |
CONTAINER_COLUMN | VARCHAR2 | (30) | 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 | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, SUMMARY_NAME
, POSITION_IN_SELECT
, CONTAINER_COLUMN
, AGG_FUNCTION
, DISTINCTFLAG
, CON_ID
FROM SYS.CDB_SUMMARY_AGGREGATES;
SYS.CDB_SUMMARY_AGGREGATES does not reference any database object
SYS.CDB_SUMMARY_AGGREGATES is referenced by following:
|
|
|