O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13Generating Reports by Grouping Related Data

CERTIFICATION OBJECTIVE

13.01 Use the ROLLUP Operation to Produce Subtotal Values

13.02 Use the CUBE Operation to Produce Crosstabulation Values

13.03 Use the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE

13.04 Use GROUPING SETS to Produce a Single Result Set

image Two-Minute Drill

Q&A Self Test

This chapter is about a number of extensions to the capabilities of the GROUP BY clause of the SELECT statement, CUBE, ROLLUP, and GROUPING SETS. We’ll also examine a function named GROUPING that supports the GROUP BY operations discussed in this chapter. Each is addressed separately in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required