Beyond master/detail reports, which you learned about in Chapter 5, there are several other advanced and less often used reporting techniques that you should know about to exploit the full power of SQL*Plus. This chapter shows you how to design totals and subtotals into a report. You'll also learn some other useful tricks and techniques involving SQL*Plus and SQL.
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Authors: Jonathan Gennick
Simiral book on Amazon