Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly)) (Paperback)

by Jonathan Gennick (Author)
Key Phrases: merging data, date format elements, standby database, Plus Pocket Reference, Oracle Database, Plus Command Reference (more...)

Editorial Reviews

Product Description
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 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 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*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.

About the Author
Gennick is a professional software developer with over twelve years of experience using a variety of platforms and technologies and is currently employed as a senior technology consultant by KPMG Peat Marwick.

Product Details

• Paperback: 154 pages
• Publisher: O'Reilly Media, Inc.; 3 edition (November 11, 2004)
• Language: English
• ISBN-10: 0596008856
• ISBN-13: 978-0596008857
• Product Dimensions: 6.9 x 4.2 x 0.6 inches
• Shipping Weight: 5 ounces (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #566,214 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #25 in	Books > Computers & Internet > Databases > Oracle > SQL
  #52 in	Books > Computers & Internet > Databases > Oracle > PL & SQL

• This item is part of The O'Reilly Pocket Guides Series.

Customer Reviews

Most Helpful Customer Reviews

17 of 18 people found the following review helpful:

4.0 out of 5 stars A Real Time Saver, May 24, 2000

By	E. Winstead - See all my reviews

This review is from: Oracle SQL Plus Pocket Reference (Paperback)

This pocket reference version has been a real time saver! I really appreciated the concise, clear explanations and examples. Since my co-workers are always walking off with it, I'm having to buy another copy for myself.

10 of 10 people found the following review helpful:

4.0 out of 5 stars A great revision guide., June 24, 2001

By	C. D. Marsh "Jackson" (Washington) - See all my reviews (REAL NAME)

This review is from: Oracle SQL Plus Pocket Reference (Paperback)

After 7 years solid experience within the ORACLE toolset I find that books like this not only teach us a few new things but are also great revision guides giving new thought to commands, formats,functions etc not used or thought of for some time.

In my opinion, even though a small book, it was well worth the money and one that all Oracle users of whatever standard will appreciate. I suggest any purchser write their name in it.

2 of 2 people found the following review helpful:

4.0 out of 5 stars Extremely Useful..., September 20, 2006

By	J H Murphy "Hank Murphy" (Agoura, California USA) - See all my reviews (REAL NAME)

...a good combination of size, price, and content. I have the 3rd edition, which includes an 8-page index. I use this as part of teaching a class in Oracle Developer and recommend it for my students. As the other reviewers recommend, write your name in it...the Oreilly pocket references are easy to misplace, and walk off sometimes. There are four blank pages at the end for your own notes. Content is adequate for its purpose -- for extensive details, the Oracle online documentation is available, if slower to access.

Drawbacks? I'd like a larger index, although the current one is useful. A little bit more room throughout the book for notes might be handy, although it would enlarge the book a bit. I think the content is about right, although there will always be things one can't find, and other topics which are never used in this type of book.

And, as with all the Oreilly pocket references I've seen, there is no colophon, so one must go to the original large book to discover that the insect on the front cover is a moving leaf, Phyllium giganteum, a Malaysian creature which grows to about four inches in length...roughly the width of the book!