Oracle SQL: Aggregate functions

Is json_dataguide() missing in this table?

The influence of null values in combination with aggregate functions.

The median()

stats_mode returns the value that occurs the most.

distinct and count

v$sqlfn_metadata can be used to query aggregate functions.

The group by clause.

NULL values in aggregate functions

listagg is an aggregate function that allows to concatenate values of different records into one record.

Aggregate functions can be nested (select sum(avg(val)) from tab group by other_val).

The aggregate clause allows to define a function that returns a single value (row?) for a set of rows.

Creating user defined aggregate functions with Data Cartridge.

The pivot clause in an select statement.

Using an aggregate function in a view prevents the view from being updatable.

The approx_for_aggregation init parameters.

Using aggregate functions on clob (or blob) values throws ORA-00932: inconsistent datatypes: expected - got CLOB.

The any_value extension introduced in 21c.