Oracle SQL*Plus Pocket Reference - Softcover

Jonathan Gennick

Softcover

ISBN 10: 8173669333 ISBN 13: 9788173669330

Synopsis

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 10g features, this handy, on-the-job guide specifically shows readers how 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 10g 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* 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.

Edition details

• Language: English
• ISBN 10: 8173669333
• ISBN 13: 9788173669330
• Binding: Paperback
• Number of pages: 160