Oracle: GROUP BY extensions

So-called group by extensions are

• rollup
• cube (produces cross-tabulation values)
• grouping sets

group by extensions produce superaggregate groupings (or superaggregate rows) in addition to ordinary group aggregates (or regular rows).

SELECT statement that contain group by extensions allow to use functions like

• grouping (?)
• grouping_id
• ?