select statement's select list
having clause
order by clause json_dataguide() missing in this table? null values in combination with aggregate functions. median() stats_mode returns the value that occurs the most. v$sqlfn_metadata can be used to query aggregate functions. group by clause. listagg is an aggregate function that allows to concatenate values of different records into one record. select sum(avg(val)) from tab group by other_val). aggregate clause allows to define a function that returns a single value (row?) for a set of rows. pivot clause in an select statement. approx_for_aggregation init parameters. clob (or blob) values throws ORA-00932: inconsistent datatypes: expected - got CLOB.