December 2002
Intermediate to advanced
928 pages
85h 29m
English
GROUPING (expr)Designed for use in SELECT statements that make use of the CUBE and ROLLUP operators. CUBE and ROLLUP both cause extra rows, with NULL values, to be inserted into a query to summarize a group of records. Returns a 1 if the NULL value is the result of an additional row returned as a result of using CUBE or ROLLUP; otherwise, returns a 0. New with Oracle8i.