Industrial-Sized Deals Best Books of the Month Shop Women's Handbags Learn more nav_sap_plcc_6M_fly_beacon $5 Albums Fire TV Stick Find the Best Purina Pro Plan for Your Pet Shop Popular Services tmnt tmnt tmnt  Amazon Echo Starting at $99 Kindle Voyage Metal Gear Solid 5 Shop Now Deal of the Day

Oracle SQL Recipes: A Problem-Solution Approach (Expert's Voice in Oracle) 2009th Edition

8 customer reviews
ISBN-13: 978-1430225096
ISBN-10: 1430225092
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.
Have one to sell? Sell on Amazon
Buy used
Buy new
More Buying Choices
23 New from $29.61 17 Used from $16.75

InterDesign Brand Store Awareness Rent Textbooks
$31.61 FREE Shipping on orders over $35. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

Oracle SQL Recipes: A Problem-Solution Approach (Expert's Voice in Oracle) + Oracle SQL Tricks and Workarounds: Expert Guide to Oracle SQL Excellence + Oracle SQL By Example (4th Edition)
Price for all three: $115.30

Buy the selected items together

Editorial Reviews

About the Author

Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.

strongBob Bryla/strong is an Oracle 8, 8ii/i, 9, and 10ig/i certified professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle database administrator at Lands' End in Dodgeville, Wisconsin. Bob works with PHP and Oracle on a daily basis to support the back end of the world's #1 clothing web site, a href=""

Darl Kuhn is a senior database administrator working for Oracle. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at Regis University in Colorado. Darl does volunteer DBA work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and lives near Spanish Peaks, Colorado, with his wife, Heidi, and daughters, Brandi and Lisa.

With extensive experience developing for the Flash platform and Java, Chris Allen is a leader in the open source Flash community. Over the last eight years, he has been a software architect and developer for various companies, including Cambridge Technology Partners, Mass General Hospital and Scholastic, Inc. Chris is president and chief executive officer of Infrared5, a consulting firm built around services for the open source Red5 server, and is co-project manager and a Java developer for the open source Red5 project.


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Series: Expert's Voice in Oracle
  • Paperback: 300 pages
  • Publisher: Apress; 2009 edition (November 20, 2009)
  • Language: English
  • ISBN-10: 1430225092
  • ISBN-13: 978-1430225096
  • Product Dimensions: 8.5 x 1.3 x 10.2 inches
  • Shipping Weight: 1.5 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #531,290 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

Most Helpful Customer Reviews

Format: Paperback Verified Purchase
Last November I pre-ordered this book, hoping that it would pick up where the "Mastering Oracle SQL and SQL*Plus" book ended (at roughly Oracle Database release The expectations were very high, and this book delivers for the most part. Some parts of the book left me scratching my head, thinking that this SQL statement or paragraph just cannot be correct. Even when taking those sections into account, this book conveys a significant amount of practical, useful information.

The book's format of problem statement, solution, and how/why the solution works is the key to the success of this book. You will not find page after page of SQL statement syntax. The range of problem statements covered in this compact 500 page book is impressive, touching on a wide range of topics:
* Basic SELECT statements
* Manipulating numbers, dates, and character data
* Transaction management
* XML data
* Partitioning
* Analytic functions
* Regular expressions
* Performance tuning
* Database troubleshooting
* Creating databases, tablespaces, tables, indexes, and constraints

* Thoroughly answers the question of why it is important to learn Oracle's dialect of SQL. The book provides 233 problem situations, most with more than one variation of the problem along with the SQL statement for each variation.
* Includes interesting side stories that are not necessarily related to SQL coding, but help to keep the reader interested in the book contents. For example, a side story titled "Beer and Statistics Do Mix" that describes the invention of T-Tests.
* Typically states when a feature requires the Enterprise Edition or an additional cost license beyond the Enterprise Edition (Tuning Pack, for example).
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Brian Hurley on January 22, 2010
Format: Paperback
Book Review: Oracle SQL Recipes - A Problem Solution Approach
Author: Grant Allen, Bob Bryla, Darl Kuhn
Publisher: Apress Inc
ISBN: 978-1-4302-2509-6

I haven't been reviewing Oracle SQL books since for the last several years my primary focus has been in the Java realm. However, I still love working directly with databases especially Oracle so I was looking forward to when this book was release and I had high hopes. Luckily the book delivers in fact I wish that I had a book just like this when I started to work with Oracle 12 years ago. It would have made the learning curve much smaller.

As most books about any technical subject they start out with the simple and head toward the more advanced. This book uses the same approach so if you're already knowledgeable about SQL you can probably skip the first 2-3 chapters. From there the book ramps up the complexity. This is where SQL starts to get really fun. The book covers many aspects of SQL programming that I have encountered over the years. Validating data between tables, dealing with NULLs, manipulating data in and between types, REGEX are just part of what this book covers. In fact I was working today and ran across a problem where I was developing new Java loaders for some large data sets. I need to compare both tables that are located on different databases to make sure that my code is working the same as the old code. I remembered a section from the book (3-9) that shows how to compare two tables and find the differences quickly. This allowed me to implement a check on several tables in just a few minutes. Otherwise I was going to write a Java program to check and compare the data in the objects which would have taken hours to write.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Zoli on August 9, 2011
Format: Paperback Verified Purchase
Very good practical guide which will walk you through examples from real life. Very helpful and easy to apply solutions sorted into logical structure. I would recommend it to professionals who dont want to loose time by reading reference guides and who dont want to spend time trying to find good solutions on internet.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Mr. Robert V. Darling on May 13, 2010
Format: Paperback Verified Purchase
I have read through this book just about from end to end and found it invaluable.

As an 'old hand' large scale mainframe system developer that came back into development just a few years back after pursuing a successful career in another field - this book really gave me considerable insight into Oracle.

The 'How it Works' explanations of the examples should be part of every technical book - and so dispell the mystery that often surrounds technical subject material.

I am currently also working through Steve Feuerstein's PL/SLQ definitive reference and the two really do complement each other for somebody who is coming to the subject with a wealth of legacy database system expertise who is looking to find out how to best make use of what is available today.

I would love to see other books constructed in the same format - for example, for the various programming languages such as Java - books that give examples of the everyday sort of things that you have to do.

Consistency is pre-requisite to Clarity and the book is consistent in its approach throughout.

Well done gentlemenOracle SQL Recipes: A Problem-Solution Approach
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

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
Oracle SQL Recipes: A Problem-Solution Approach (Expert's Voice in Oracle)
This item: Oracle SQL Recipes: A Problem-Solution Approach (Expert's Voice in Oracle)
Price: $31.61
Ships from and sold by

Want to discover more products? Check out these pages to see more: software engineering, computer programs