Skip to Main Content
Feature Request FR-4978
Product Area Page Components
Status OPEN

3 Voters

support GROUP BY ALL (26ai) in interactive reports

peter de vaal Public
· Aug 5 2026

Idea Summary
In interactiev reports end users can make custom reports with aggergations using GROUP BY. However, the number of GROUP BY columns/expressions is limited. In Oracle 26ai the new GROUP BY ALL is introduced, which would lift this limit.

Use Case
Users like to have reports that can aggregate over more than the restricted number of columns in the GROUP BY. With Oracle 26ai this should be possible if interactive reports supports it

Preferred Solution (Optional)
Allow to select ALL as the GROUP BY expression

This idea is open.