Oracle SQLPlus Pocket Reference

Jonathan Gennick

ISBN 10: 0596008856 / ISBN 13: 9780596008857

Published by O'Reilly Media, Inc, USA, 2004

This portable, quick-reference guide is a must-have for developers and DBAs looking to maximize use of SQL*Plus. The new third edition of the' Oracle SQL*Plus Pocket Reference' updates the SQL*Plus syntax and format options for Oracle Database 10g, Oracle's latest database release. Num Pages: 146 pages, Illustrations. BIC Classification: UNSB. Category: (G) General (US: Trade); (P) Professional & Vocational. Dimension: 179 x 109 x 10. Weight in Grams: 152. . 2004. 3rd Edition. paperback. . . . . Seller Inventory # V9780596008857

Synopsis:

The Oracle SQLPlus 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, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:

• Differentiate between SQL and SQLPlus
• 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 SQLPlus
• Specify SQLPlus 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 SQLPlus 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 SQLPlus 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 SQLPlus: 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.

Book Description: A Guide to SQL*Plus Syntax

Bibliographic Details

Title: Oracle SQLPlus Pocket Reference
Publisher: O'Reilly Media, Inc, USA
Publication Date: 2004
Binding: Soft cover
Condition: New
Edition: 3rd Edition