
-- gb_10a.sql
-- original

-- show that grouping() returns 1 for Superaggregate rows

set autotrace off echo off

select dummy, grouping(dummy) grp
from dual
group by cube(dummy)

l

/



