Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Oracle SQL Plus Pocket Reference [Paperback]

Jonathan Gennick
3.5 out of 5 stars  See all reviews (2 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Paperback 5.98  
Paperback, 11 April 2000 --  
There is a newer edition of this item:
Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly)) Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly)) 3.5 out of 5 stars (2)
In stock.

Book Description

11 April 2000 1565929411 978-1565929418 1

This pocket reference provides quick reference information that will help you use SQLPlus, Oracle's interactive query tool. It summarizes all of the SQLPlus syntax, including the syntax for new Oracle8i release 8.1.6 features.SQLPlus 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 SQLPlus can be.This book boils down the most vital information from Gennick's best-selling book, Oracle SQLPlus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQLPlus, selecting data, formatting reports with SQLPlus, and tuning SQL queries. It also contains quick references to the SQLPlus commands and format elements.This book is an indispensable companion to O'Reilly bestselling book, Oracle SQLPlus: The Definitive Guide, but it does not replace it; the larger book is truly the definitive guide, suitable for readers at all levels of expertise. The definitive guide describes the many tasks that SQLPlus can perform, and provides a tutorial on many SQLPlus topics. But this quick reference is an excellent, portable resource for readers who want a pocket-sized summary of SQLPlus capabilities and a reminder of how to issue specific commands and formatting options for SQLPlus.Table of Contents:

  1. Interacting with SQL

  • Selecting Data
  • Formatting Reports
  • Tuning SQL
  • SQLPlus Format Elements
  • SQLPlus Command Reference

  • Product details

    • Paperback: 94 pages
    • Publisher: O'Reilly Media; 1 edition (11 April 2000)
    • Language: French
    • ISBN-10: 1565929411
    • ISBN-13: 978-1565929418
    • Product Dimensions: 17.7 x 10.7 x 0.8 cm
    • Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
    • Amazon Bestsellers Rank: 2,218,203 in Books (See Top 100 in Books)
    • See Complete Table of Contents

    More About the Author

    Discover books, learn about writers, and more.

    Product Description

    Amazon Review

    This small slim volume is a concise guide to using Oracle's SQL*Plus tool which acts as a front-end to the SQL querying language. Oracle SQL*Plus Pocket Reference does not attempt to teach you how to use the language but provides a quick reference to the commands available and the ways in which they can be pressed into service.

    It's terse but informative, as befits a pocket guide, and so small that the usually entertaining O'Reilly colophon is omitted--which is a shame. The first half covers basic interactions such as string handling and naming variables, moving on to deal with selecting data, formatting reports and tuning SQL statements plus a section on formatting elements that let you do almost anything with number and date displays, including showing dates with a BC or AD indicator. In the tuning section there is brief coverage of execution plans for SQL statements and of how to tune the Oracle optimiser that puts those plans into operation. The second half forms the SQL command reference section, everything from ACCEPT to WHENEVER.

    This eminently pocketable reference book would be invaluable for jogging the memory in those odd moments of blankness-- and it's almost palmable if you're shy about admitting fallibility. --Mark Whitehorn


    ".....In summary, if you're planning on regular use of SQL*Plus, this book is essential.....My rating: 9.5/10" -- hanksdc, Provo Linux Users Group, May 2002

    Inside This Book (Learn More)
    Browse and search another edition of this book.
    Browse Sample Pages
    Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
    Search inside this book:

    Sell a Digital Version of This Book in the Kindle Store

    If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

    What Other Items Do Customers Buy After Viewing This Item?

    Customer Reviews

    5 star
    2 star
    1 star
    3.5 out of 5 stars
    3.5 out of 5 stars
    Most Helpful Customer Reviews
    6 of 6 people found the following review helpful
    3.0 out of 5 stars Good quick reference book 21 Jun 2000
    By A Customer
    If you're looking for a compact quick reference book on SQL*Plus then this'll do the job. The second half the text is purely given over to listing the commands in alpha order, with short examples, but if you want more on SQL query statements (other than "select"), then look elsewhere. On the whole, it does what it sets out to do.
    Comment | 
    Was this review helpful to you?
    4.0 out of 5 stars Taught me a thing or two 25 Jun 2003
    By Gromit
    Format:Paperback|Verified Purchase
    I've been in Oracle development for quite a while, and find that as the toolset develops, it becomes more difficult to remember everything that Oracle introduces on each new release. This book is an excellent, concise reference book, excellent for jogging the memory. Additionally, it had a couple of topics which I wasn't aware of and I've since used them on a live problem, so for me the book has already paid for itself. One criticism though, was I couldn't find information on the CUBE and ROLLUP functions. It covers 'GROUP BY' so I thought that it would have these too. This is a minor point, but is reflected in the four star rating. Highly recommended as a dip-in reference.
    Comment | 
    Was this review helpful to you?
    Most Helpful Customer Reviews on Amazon.com (beta)
    Amazon.com: 4.2 out of 5 stars  9 reviews
    17 of 18 people found the following review helpful
    4.0 out of 5 stars A Real Time Saver 25 May 2000
    By E. Winstead - Published on Amazon.com
    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.
    2 of 2 people found the following review helpful
    4.0 out of 5 stars Extremely Useful... 20 Sep 2006
    By J H Murphy - Published on Amazon.com
    ...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!
    5.0 out of 5 stars Me gusta mucho el formato y la reputación de la editorial. 24 Jun 2014
    By Pablo Zurita - Published on Amazon.com
    Format:Paperback|Verified Purchase
    Having a guide of this size on hand, it is very useful for quick reference and consultation in the office. Its content seems appropriate and well treated the subject matter. I like the publisher.
    4.0 out of 5 stars Good reference book 10 Aug 2013
    By Fred C. Howard - Published on Amazon.com
    Format:Paperback|Verified Purchase
    I did enjoy the book and use often for reference to Oracle. This book is easy to read and is complete.
    5.0 out of 5 stars Well written 17 April 2013
    By Live to read - Published on Amazon.com
    Format:Paperback|Verified Purchase
    This has become a staple of my office reference library, and I have to attach a big stick to it or it keeps disappearing. Highly recommended for anyone needing a quick reminder.
    Were these reviews helpful?   Let us know
    Search Customer Reviews
    Only search this product's reviews

    Customer Discussions

    This product's forum
    Discussion Replies Latest Post
    No discussions yet

    Ask questions, Share opinions, Gain insight
    Start a new discussion
    First post:
    Prompts for sign-in

    Search Customer Discussions
    Search all Amazon discussions

    Look for similar items by category