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 theOWNER
orORIGIN_CON_ID
columns.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the analytic view |
|
|
|
Name of the analytic view |
|
|
|
Aggregation group name of the analytic view aggregation function |
|
|
|
Name of the analytic view aggregation function |
|
|
|
Depth of the inner aggregation function |
|
|
|
Column that indicates if the function uses the distinct modifier |
|
|
|
The ID of the container where the data originates. Possible values include:
|
Note:
This view is available starting with Oracle Database 21c.
See Also: