CHAPTER 6Basic SQL*Plus Reports and Commands
SQL*Plus is usually thought of as a tool to manipulate data and perform ad hoc queries against the database; it can also function as an interactive report writer. It uses SQL to get information from the Oracle database, and it lets you create reports by giving you easy control over titles, column headings, subtotals and totals, reformatting of numbers and text, and much more. It also can be used to change the database through the insert, update, merge, and delete commands in SQL. SQL*Plus can even be used as a code generator, where a series of commands in SQL*Plus can dynamically build a program and then execute it.
In most production applications, more-advanced report writers are used—such as Web-based ...
Get Oracle Database 11g The Complete Reference 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.
