Can some one provide a good example of usage of grouping_id rollup ?
This article http://www.revealnet.com/newsletter-v6/0705_B.htm
has something, but not good enough.
I like to see more columns are used and how the DECODE (GROUPING_ID like the following works out. Thanks.
DECODE (GROUPING_ID (line_lvl_1,