Automotive Holiday Deals Books Holiday Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Indie for the Holidays egg_2015 All-New Amazon Fire TV Subscribe & Save Gifts for Her May The Best Garden Be Yours Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals Shop Now DOTD
Pro Oracle SQL (Expert's Voice in Oracle) and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Pro Oracle SQL (Expert's Voice in Oracle) 2010th Edition

9 customer reviews
ISBN-13: 978-1430232285
ISBN-10: 1430232285
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $6.37
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$10.21 - $13.06 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$25.52 On clicking this link, a new layer will be open
More Buying Choices
20 New from $20.00 21 Used from $14.01

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks
$25.52 FREE Shipping on orders over $35. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • Pro Oracle SQL (Expert's Voice in Oracle)
  • +
  • Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases)
Total price: $53.51
Buy the selected items together

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

Editorial Reviews

About the Author

Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior Technical Consultant for Enkitec. For more than 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a database administrator, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90s, she began teaching others how to use Oracle over a decade ago. Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network (an informal association of "Oracle scientists" that are well known throughout the Oracle community). She blogs at

Product Details

  • Series: Expert's Voice in Oracle
  • Paperback: 600 pages
  • Publisher: Apress; 2010 edition (December 16, 2010)
  • Language: English
  • ISBN-10: 1430232285
  • ISBN-13: 978-1430232285
  • Product Dimensions: 7.5 x 1.4 x 9.2 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #920,553 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

5 star
4 star
3 star
2 star
1 star
See all 9 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

8 of 8 people found the following review helpful By Dean Alomerovic on February 23, 2011
Format: Paperback
The book is for Oracle professionals almost exclusively - the other RDBMS are not covered. I've found the book very useful to both developers and DBAs (I happened to be wearing both hats) in day to day activities.

The authors have assumed you are already in the Oracle field. If you are not, then the material may often overwhelm you. Novices can find more suitable books out here for sure. By the time you are through the book, you'll be up several levels when it comes to writing better SQL or understanding better already written SQL.

I give all 5 STARS to the authors of the book for the great job done on demystifying SQL execution plans. The book shows and analyzes execution plans over and over again until they become your second nature. It took chapters 2 through 6 to build the necessary background and take readers to the very hart of execution plans. The rest of the book also uses the plans as the main tool for SQL characterization and performance analysis.

Page 165 shows how to read an exec plan as a plain English narrative. In my experience, this is highly useful for:
1. Putting yourself in the shoes of Oracle Optimizer - think the way HE thinks.
2. Presenting in plain English the SQL execution problems to inquisitive but less-technical folks, from VPs and directors to functional users.

My experience has thought me that being able to understand, interpret, assess and compare SQL execution plans is a great skill to have.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Hard-Hitting, Beyond the Basics Advice for Breaking the Black Box Approach to Database Programming, Leveraging the SQL Language on Oracle Database, and Improving Overall Performance of the SQL that You Write

I pre-ordered this book in October 2010 while searching for a way to learn some of the more advanced features of Oracle Database's SQL; I have been searching for a follow up book to the "Mastering Oracle SQL and SQL*Plus" book that I read a couple of years ago, and I think that I finally found that follow up book. Written as the Oracle Database 11.2 sequel to the book "Mastering Oracle SQL and SQL*Plus" (and that book's much updated revision titled "Beginning Oracle SQL"), this book is not written as a simple reference for the Oracle specific SQL dialect. This is not a book that you will want to use when trying to learn the basics of creating a simple SQL statement with a four table join. However, if you are able to create that simple SQL statement with a four table join in less than 30 minutes with the help of an entity-relationship diagram (ERD), and without using a DISTINCT clause, this book's contents will prove to be a valuable resource not only to expand your depth of knowledge of the SQL language, but also to extract the extra value that becomes visible when Oracle Database is viewed as much more than a black box dumping ground for data.

The authors of this book are all OakTable Network members and have between 15 and 29 years of experiencing working with Oracle products. This long term exposure to Oracle Database is quite clearly an advantage when discussing many of the subtopics that are simply missed by other Oracle specific SQL language references. While there was no discussion of the SQL language from Oracle Database 2.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
3 of 3 people found the following review helpful By Scott on December 30, 2010
Format: Paperback
This is not a book for learning to write SQL - you need to know how to do that before you read this book. This is a book for learning to write better SQL with Oracle. Nearly every example is accompanied by SQL that enable you to determine that this specific example is in fact better and why. So you won't just learn that SQL technique, you'll also learn to investigate other SQL statements. It is also is solely focused on Oracle - it won't help you with other DBMS's.

Ignore chapter One - it's not indicative of the rest of the book. It covers only things you ought to already know and rightly redirects you elsewhere if you don't understand any of it.

You'll want to have an Oracle system available to you as you read this book, so that you can try out the examples. It should be a system where you can freely experiment because you will want to create tables, run the SQL and then look at the explain results in the Plan tables.

I did especially like Chapter 5 - "It's about the Question" -- you do really need to understand what you are trying to retrieve before you write the query. That chapter is about determining what the question really is. This is perhaps the only chapter that is independent of the database system.

There's a lot of information in this book and many times I found I was picking up things that were new to me, even though I have been working with Oracle for some years (and SQL for many more years).
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By David Raj Daniel on September 13, 2011
Format: Paperback Verified Purchase
Few books shaped my approach to Understand Oracle architecture and systematize Oracle tuning. 1. Expert one on one -Tom Kyte 2. Effective Oracle by design -Tom Kyte 3. Optimizing oracle performance -Cary Milsap 4.CBO fundemantals -Jonathan Lewis 5. TOP -Christian Antognini. This book also should definetly be in one's Oracle Library. It covers a good skill range. One need not be an expert to read this.It has contents which provides information to the one with Basic skills,Intermediate skills or Advanced.A good understanding of SQL is a prerequisite before understanding advanced concepts like RAC,Exadata etc.
This books does a great job in refreshing what you already know and enriching with
lot of additional information.Though all the chapeters in the book were good. The chapters from Kerry Osborne is Excellent. Any developer/DBA working on a complex production system should read Chaper 16. Plan stability and Control. Trouble shooting Oracle perfomance from Christian Antognini addresses this topic in great length ,but still there are some additional information.
The scripts provided alongside is extremely useful as well.

The chapters from the other authors were also pretty interesting and well researched.

I am planning to write another review on Expert Oracle Exadata by Kerry Osborne,Randy Johnson,Tanel Poder which is the Bible for Exadata as of today.

Overall excellent value for money.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Pro Oracle SQL (Expert's Voice in Oracle)
This item: Pro Oracle SQL (Expert's Voice in Oracle)
Price: $25.52
Ships from and sold by