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: