Oracle SQL*Plus: The Definitive Guide: The Definitive Guide and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Oracle SQL*Plus on your Kindle in under a minute.

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

Oracle SQL*Plus: The Definitive Guide [Paperback]

Jonathan Gennick
3.7 out of 5 stars  See all reviews (12 customer reviews)
Price: CDN$ 57.95 & FREE Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Thursday, October 23? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $19.34  
Paperback CDN $57.95  
Join Amazon Student in Canada

Book Description

Nov. 26 2004 0596007469 978-0596007461 Second Edition

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly:

  • write and execute script files
  • generate ad hoc reports
  • extract data from the database
  • query the data dictionary tables
  • customize an SQLPlus environment
  • and much more
It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

Customers Who Bought This Item Also Bought

Product Details

Product Description


'One puzzling aspect of the O'Reilly series is how the publishers have managed to find such competent authors when other companies seem unable to get anyone who can string a sentence together. You really get the feeling that the authors want to tell you how to solve a problem rather than demonstrate how clever they are. ... Oracle SQL*Plus is a strong candidate for the bookshelf, with information you'd otherwise have to check in four of the Oracle manuals, and There's a human voice helping you.' Computer Shopper, July 2000 --This text refers to an alternate Paperback edition.

From the Publisher

This book is the definitive guide to SQL*Plus, Oracle's interactive query tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, provides a syntax quick reference, and describes how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, use the SQL*Plus administrative features (new in Oracle8i), and much more. --This text refers to an alternate Paperback edition.

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

Customer Reviews

Most helpful customer reviews
4.0 out of 5 stars Good book for a beginner! May 8 1999
By A Customer
I've been using the book at home with Oracle 8.0.5 for linux and it has been very helpful - I'm an Oracle novice. I would have rated it higher, but the index and/or grouping of some of the concepts is not consistent. For example, one reader noted that the text refers you to chapter 11 to set your default editor - then does not tell you how to do this in chapter 11. As far as I could see, this is true - chapter 11 does not tell you how to do this - but in chapter 4 there is an *example* that shows how to do this (DEFINE _EDITOR = vi). I liked the sections on report and script writing, I thought they were concise yet easy to follow. Overall, I'd recommend the book to another newbie
Was this review helpful to you?
1.0 out of 5 stars Another useless book from O'Reilly April 7 1999
By A Customer
This is an another useless book from O'Reilly. You might better use on-line documentation. Most of the things are already what you know, or you can get them from on-line documentation. For the beginners of sql-plus, it won't help. When you really need some info, it doesn't have it. For example, in page 57, it says, "You may, however, configure SQL*Plus to use another editor of your choice. Chapter 11 tells you how to do this". Chapter 11 is indeed "Customizing your SQLPlus Environment". However, it is simply a list of SET commands, and it does not explain anything about setting up the editor of my choice at all !!!
Was this review helpful to you?
By "sinaj"
SQL-Plus is a fundamental tool but it is hard to find a useful guide on the topic in the market. And I am glad finally there is one.
Oracle Sql Plus: The Definitive Guide is really interesting to read. The author writes in a friendly style and depicts each topic with lots of examples ( so many and so usful that you can add to your own libraries ).
Personally, I am much appealed by the author's discussion on reporting, writing scripts and setting environment. If you are not familiar with any of these, you will be greatly awarded when finishing the book. I can bet it!
Was this review helpful to you?
5.0 out of 5 stars The most accurate SQL*Plus reference April 1 1999
This book finally answers a need for SQL*Plus users that need something more than a quick reference card, but not an inaccurate tome, like "Oracle 8: the complete reference".
For instance, when it comes to looping, on page 254 you can read "There is no way to write a real loop using SQL*Plus." If you see this, you won't search through another 100 pages of manual trying to find a meaningful example. Excellent, correct, and an excellent balance between conciseness and completeness.
I have even adopted this book for my undergraduate database class.
Was this review helpful to you?
3.0 out of 5 stars not very good Jan. 7 2000
I must admit that I am somewhat disappointed with this book. To me, an SQL Plus book should deal with using the most basic and useful commands, for example, various powerful functions, date handling, etc. This books covers some PL./SQL , Oracle load , tuning and administration -- strictly speaking not part of SQL Plus. With the widespread use of Developer 2000, the Report Writing part of SQL Plus is losing its importance and there should not be given too much coverage. For one trying to take the Oracle Certification in SQL Plus, this is not a suitable book
Was this review helpful to you?
3.0 out of 5 stars It didn't solve my problems... Aug. 2 2001
Having been a user of SQL*Plus for over 10 years I was hoping to find some answers to more advanced topics rather than the basics. The coverage of how SQL*plus scripts are driven from O/S batch or shell scripts is sorely lacking. This is a rich area not effectively covered in any text that I'm aware of. Several areas don't tell the full story - or fail to highlight subtle differences in syntax (e.g. yy vs. rr in date formatting).
Having said all that, I still regularly use this book as a reference and continue to learn from it.
Was this review helpful to you?
Want to see more reviews on this item?
Most recent customer reviews
Search Customer Reviews
Only search this product's reviews

Look for similar items by category