Skip to Main Content
Oracle9i™ Development by Example
book

Oracle9i™ Development by Example

by Dan Hotka
December 2001
Intermediate to advanced content levelIntermediate to advanced
640 pages
15h 11m
English
Que
Content preview from Oracle9i™ Development by Example

Advanced SQL*Plus Reporting Features Techniques

This is the final section of Chapter 7. “Using Advanced SQL Techniques and SQL*Plus Reporting Features,” discusses more advanced reporting features of SQL*Plus: creating a cross-tabular report, using substitution variables from the operating-system command line along with a pre-formatted output result, and creating a master/detail report.

Cross-tabular reports are easy to do with a mix of SQL and SQL*Plus formatting commands. Listing 7.2 shows the CH3_XREF.SQL SQL*Plus script file and Listing 7.3 shows the output cross-tabular report from this script file. Notice again that there is a command line field that is passed in and appears in the heading. In this case, it is a report date. Notice the new ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Communicate with Teams More Effectively

Communicate with Teams More Effectively

Charles Humble
Oracle® Web Application Programming for PL/SQL® Developers

Oracle® Web Application Programming for PL/SQL® Developers

Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig

Publisher Resources

ISBN: 0789726718Purchase book