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 ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
