Oracle SQL?Plus Pocket Reference 3e (Paperback, 3rd Revised edition)

The "Oracle SQL*Plus Pocket Reference" is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle's long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized.

Database administrators and developers alike will therefore find the "Oracle SQL*Plus Pocket Reference" to be extremely beneficial. In addition to summarizing all of the SQL*Plus syntax and format options, including new Oracle Database 10"g" features, this handy, on-the-job guide specifically shows readers how to:

Differentiate between SQL and SQL*Plus

Interact with SQL*Plus from both the command line and the web browser

Select, insert, update, and delete data

Format both text and HTML reports with SQL*Plus

Specify SQL*Plus commands and format elements

Tune SQL queries

The new third edition of this book has been updated for Oracle Database 10"g" to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.

With its quick-reference format and compact size, the "Oracle SQL*Plus Pocket Reference" follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQL*Plus, the bestselling "Oracle SQL*Plus: The Definitive Guide,"

Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.