Pages

Wednesday, 22 January 2014

GROUPING Function In Oracle

The
Grouping function can be used with either the
cube or rollup operator. Using this
function we can find the basis on which the groups are formed and it’s subtotal.
It accepts a single column as a parameter and returns numeric values to
identify the column value in an aggregated row. It returns 1 if the column
contains a null value generated as part of a subtotal by a ROLLUP or CUBE
operation and zero if it is NOT NULL