Chapter 5. Generating Reports with SQL*Plus

SQL*Plus is an effective reporting tool. You can count on having SQL*Plus available in any Oracle environment, and it gets the job done well with a minimum of fuss. SQL*Plus was originally a plain-text reporting tool, but HTML support was added in Oracle8i Database Release 2. This HTML support makes SQL*Plus a handy tool for generating web reports for corporate Intranets, and I describe that support next in Chapter 6.


iSQL*Plus is good for ad hoc query execution but not so good for polished report generation because you can’t spool iSQL*Plus output to a file for later printing.

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.