Oracle GROUP by specified column total GROUP by rollup ()

GROUP BY rollup () total by group

Select Grouping (status), Status,owner,object_type,count (*) from dba_objects

where owner not in (' SYS ', ' SYSTEM ')

GROUP BY rollup (Status,owner,object_type)

Order BY Status,owner,object_type;

Classic categorical Query statements:

Select Object_type,count (*) from

(Select Decode (object_type, ' table ', ' table ', ' index ', ' index ', ' OTHERS ') object_type from Dba_objects)

GROUP BY rollup (object_type);

Oracle GROUP by specified column total GROUP by rollup ()