Oracle SQL*Plus Pocket Reference, 3rd Edition

Appendix A. O’reilly^®: Oracle SQL*Plus Pocket Reference

Oracle/Database

SQL*Plus is an interactive query tool that’s ubiquitous in the Oracle world. It’s available at every Oracle site—from the largest data warehouse to the smallest single-user system—and it’s a critical tool for virtually every Oracle user.

The third edition of this popular pocket guide provides quick reference information on SQL*Plus syntax and format elements, including new Oracle Database 10g features. It concisely describes interacting with SQL*Plus, formatting both text and HTML reports with SQL*Plus, and tuning SQL queries using both optimizer hints and the plan table. This new edition covers browser-based iSQL*Plus, the ability to generate HTML, new commands and SET options, and much more. It also contains expanded information on the SQL statements most commonly issued from SQL*Plus (SELECT, INSERT, UPDATE, DELETE, MERGE, COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION) and adds coverage of new SQL features such as the Oracle Database 10g SELECT statement’s MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.

Jonathan Gennick is also the author of SQL Pocket Guide, Oracle SQL*Plus: The Definitive Guide, Oracle SQL*Loader: The Definitive Guide, and a number of other database books.