Oracle SQL*Plus Pocket Reference of Jonathan Gennick as eBook reading on PaperC.

Please ugprade your Internet Explorer to use all of the PaperC functions.

Oracle SQL*Plus Pocket Reference

Please follow http://www.adobe.com/go/getflashplayer and install the Adobe Flash Player.

Do you like this document?

Notes

Please login to add notes

Inhaltsverzeichnis
Notes
About this book

The _Oracle SQL_Plus Pocket Reference__ 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_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 SQLPlus 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 SQLPlus 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 SQLPlus 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 SQLPlus, 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.