Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))

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.