O'Reilly logo

Oracle SQL*Plus Pocket Reference, 3rd Edition by Jonathan Gennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Oracle/Database

image with no caption

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.

image with no caption

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required