Oracle SQL Plus Pocket Reference (Paperback)

by Jonathan Gennick (Author)

Editorial Reviews

Product Description
This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements.

About the Author
Jonathan Gennick is an independent consultant and computer book author specializing in Oracle technologies. He got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. In 1994 he made the leap to Oracle, and hasn't looked back yet. Much of his time is spent providing database administration services, as well as server-side PL/SQL support, to clients and internal project teams. When he is not working with Oracle, Jonathan can often be found writing about it. Recent projects include Oracle SQL*Plus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); Oracle8i DBA's Bible (IDG Books, 2000); and Teach Yourself PL/SQL in 21 Days, Second Edition (SAMS Publishing, 1999). Writing has given Jonathan the opportunity to pursue several interests outside of his normal day-to-day work. He is a member of the technology committee for the Greater Lansing Adventist School, and he manages the web site for his local church. This satisfies his gnawing need to learn, and also his desire to help others. Jonathan is a member of MENSA. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Lansing, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at [e-mail].

Product Details

• Paperback: 90 pages
• Publisher: O'Reilly; 1 edition (May 15, 2000)
• Language: English
• ISBN-10: 1565929411
• ISBN-13: 978-1565929418
• Product Dimensions: 6.8 x 4.2 x 0.3 inches
• Shipping Weight: 3.2 ounces
• Average Customer Review: 3.8 out of 5 stars See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #1,533,276 in Books (See Bestsellers in Books)

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

  #51 in	Books > Computers & Internet > Databases > Oracle > SQL
  #98 in	Books > Computers & Internet > Databases > Oracle > PL & SQL

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 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)

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)

This review is from: Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly)) (Paperback)

...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!