Chapter 9. Reporting Techniques
It's important that the data returned from a query be presented in a manner that is easy to interpret. The reporting features of iSQL*Plus, SQL*Plus, and SQL*Plus Worksheet make it easy to give columns more meaningful names, as well as provide report headers and footers so that the contents of the report are clear.
In fact, changing how reports are formatted and displayed is one way that you can customize the iSQL*Plus environment to suit your needs. You can also change how the interface appears and change an account's password.
Along with formatting, another way to improve a report is by using substitution variables, which prompt the user to enter portions of the query at runtime. For example, instead of including ...
Get Oracle Database Foundations 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.
