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)
List Price: CDN$ 57.95
Price: CDN$ 26.30 & FREE Shipping. Details
You Save: CDN$ 31.65 (55%)
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 Wednesday, July 30? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $18.54  
Paperback CDN $26.30  
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 A NICE SEQUEL TO "ORACLE PL/SQL" Jan. 12 2003
Jonathan Gennick and co did a good job here. This "Oracle SQL Plus: The Definitive Guide" would be appreciated by most users, although that advanced SQL users who thirst for a unique guidance, having understood the elementary basics of SQL are its primary target. The medium-sized book boasts of updated and revised information whose accuracy are indisputable. Its methodology is as well, dynamic. The pattern of this book is such that tries to turn difficult issues into entertaining ones. It is worth its asking price.
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?
5.0 out of 5 stars A great book for an Introduction to SQL Plus March 15 2001
By A Customer
As a mainframe programmer making the transition to the client-server environment, I found this book to be a great introduction to SQL*Plus. The one thing that became immediately apparant (while reading the book), was that one had to work through the examples with SQL*Plus. Gennick is a good author and is able to get the material across in an efficient and effective manner. I highly recommend this book to any individual desiring an introductory and working knowledge of SQL Plus.
Was this review helpful to you?
5.0 out of 5 stars A good quick start! Oct. 27 2000
Oracle was new to me, although I've worked with other RDBMSs, and I needed a reference for the SQL Plus interface. Gennick's book turned out to be just the thing. The writing is clear, there are lots of examples, and the topics are inclusive -- from the basic environment to advanced scripting and tuning. I've recommended this book to students.
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?
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?
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