3.14 ALL_ANALYTIC_VIEW_AGGR_FNS

ALL_ANALYTIC_VIEW_AGGR_FNS describes the aggregation functions of the analytic views accessible to the current user.

Related Views

• DBA_ANALYTIC_VIEW_AGGR_FNS describes the aggregation functions of all analytic views in the database.

• USER_ANALYTIC_VIEW_AGGR_FNS describes the aggregation functions of the analytic views owned by the current user. This view does not display the OWNER or ORIGIN_CON_ID columns.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the analytic view
ANALYTIC_VIEW_NAME	VARCHAR2(128)	NOT NULL	Name of the analytic view
AGGR_GROUP_NAME	VARCHAR2(128)	NOT NULL	Aggregation group name of the analytic view aggregation function
FUNCTION_NAME	VARCHAR2(128)		Name of the analytic view aggregation function
DEPTH	NUMBER	NOT NULL	Depth of the inner aggregation function
IS_DISTINCT	VARCHAR2(1)		Column that indicates if the function uses the distinct modifier
ORIGIN_CON_ID	NUMBER		The ID of the container where the data originates. Possible values include: 0: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root).

Note:

This view is available starting with Oracle Database 21c.

See Also:

• "DBA_ANALYTIC_VIEW_AGGR_FNS"

• "USER_ANALYTIC_VIEW_AGGR_FNS"