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

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

<div><p>The <i>Oracle SQL<em>Plus Pocket Reference</em></i> is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQL<em>Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL</em>Plus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the <i>Oracle SQL<em>Plus Pocket Reference</em></i> to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10<i>g</i> features, this handy, on-the-job guide specifically shows readers how to:</p><ul><li>Differentiate between SQL and SQL<em>Plus</em></li><li>Interact with SQLPlus from both the command line and the web browser</li><li>Select, insert, update, and delete data</li><li>Format both text and HTML reports with SQL<em>Plus</em></li><li>Specify SQLPlus commands and format elements</li><li>Tune SQL queries</li></ul>The new third edition of this book has been updated for Oracle Database 10<i>g</i> to include information on both SQL<em>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 <i>Oracle SQL</i></em>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<em>Plus, the bestselling <i>Oracle SQL</i></em>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.</div>