Oracle PL/SQL Recipes: A Problem-Solution Approach and over 2 million other books are available for Amazon Kindle . Learn more
  • RRP: £47.49
  • You Save: £15.99 (34%)
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
Oracle PL/SQL Recipes: A ... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Oracle PL/SQL Recipes: A Problem-Solution Approach (Expert's Voice in Oracle) Paperback – 10 Dec 2010

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£25.78 £28.36
£31.50 FREE Delivery in the UK. In stock. Dispatched from and sold by Amazon. Gift-wrap available.

Product details

  • Paperback: 456 pages
  • Publisher: Apress; 2010 edition (10 Dec. 2010)
  • Language: English
  • ISBN-10: 1430232072
  • ISBN-13: 978-1430232070
  • Product Dimensions: 19 x 2.6 x 23.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 1,639,737 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

About the Author

Josh Juneau has been developing software since the mid-1990s. PL/SQL development and database programming was the focus of his career in the beginning, but as his skills developed, he began to use Java and later shifted to it as a primary base for his application development. Josh has worked with Java in the form of graphical user interface, web, and command-line programming for several years. During his tenure as a Java developer, he has worked with many frameworks such as JSF, EJB, and JBoss Seam. At the same time, Josh has extended his knowledge of the Java Virtual Machine (JVM) by learning and developing applications with other JVM languages such as Jython and Groovy. His interest in learning new languages that run on the JVM led to his interest in Jython. Since 2006, Josh has been the editor and publisher for the Jython Monthly newsletter. In late 2008, he began a podcast dedicated to the Jython programming language.

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

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

Format: Kindle Edition
As a developer looking to expand my knowledge of the Oracle database, and particularly look at PL/SQL for ways to improve performance and error handling, this book worked well for me. As it says in the title, it's orientated towards providing solutions to specific problems. Want to know how to catch exceptions? Chapter 9 starts with a brief introduction to exceptions and then provides a detailed worked example. Wish Oracle had a MySQL-style AUTO_INCREMENT column option? Chapter 5 starts with a demonstration of how to get the same effect with triggers.

This means less time spent learning the basics in depth before you can do something, which is ideal for experienced developers who are likely to know what they want to do. For anyone who hasn't developed programs before (e.g. an Oracle DBA looking to learn PL/SQL), this may not be the best place to start (that said, it might simply be better to start with a different language, Python or Java would be good fits, and then come back to this).

Recommended to existing developers.
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

Most Helpful Customer Reviews on (beta) 5 reviews
4 of 4 people found the following review helpful
PL/SQL Recipes 4 Jan. 2011
By Doug Duncan - Published on
Format: Paperback
Oracle PL/SQL Recipes is, as one can guess, a "cookbook" for how to do things in PL/SQL. As is typical for these types of book you are presented with a problem, solution and then a description of how things work.

The book is grouped into 17 chapters each dealing with a different aspects of PL/SQL and then subdivided into 10 - 20 "recipes". While this book will help the beginner in getting an understanding of how things are done in PL/SQL it is not necessarily a resource to learn the specifics of PL/SQL. Most of the recipes in this book can be read and put into practice in just a few minutes.

The book starts with chapters on the basics, such as fundamentals of PL/SQL, essential SQL tasks, building functions, procedures and triggers. The later chapters move on to more advanced topics such as analyzing and improving performance, using Java in the database and unit testing with utPLSQL.

There are a few recipes that are put in to show solutions that some legacy applications may be using. The authors are pretty good about calling these solutions out and suggesting recipes that are more suitable for new applications. While some of the problems and solutions seem to be more contrived than they need to be and there are other solutions that would probably be better suited to the task at hand, the book does a good job at presenting useful problems and solutions.

While I did not try all the code provided in the book (there is a download available from Apress if you don't want to type it all out), it seems that it was tested to verify that there were no syntax problems. There was one exception to this that was easily noticed (recipe 4.19) where it looks like the author wrote some SQL code, changed the text and then didn't get the code changed correctly. The download provides not only the scripts presented in the individual recipes, but also the scripts to create the objects that are used throughout the book. I can't speak to the validity of the code in the download as I only used the the scripts to generate the objects. I would rather type code to help learn (as I usually make mistakes that need to be corrected ;) ).

Even with the minor problems in editing (seems all tech books have these issues), this is definitely a book worth checking out. The simple to use recipes can help you get going in the right direction to solve your problems.
3 of 3 people found the following review helpful
Recipes for the PL/SQL Developer / DBA 20 Dec. 2010
By Amazon Customer - Published on
Format: Paperback
There is definitely something for everyone in "Oracle PL/SQL Recipes", whether you are beginning to learn PL/SQL or have been using the language for many years.

I like the "Problem - Solution Approach" format, and the "How It Works" explanation that is included with each example, as it helps drive home the concept and where the recipe can be used.

You also don't need to read this book from beginning to end, as you can locate the specific problem you are having and learn how to apply the solution to your own code.

The book starts off with the fundamentals that are needed to get you going in PL/SQL, and then moves onto the more advanced topics.

Topics include :

* PL/SQL Fundamentals
* Essential SQL
* Looping and Logic
* Functions, Packages, and Procedures
* Triggers
* Type Conversion
* Numbers, Strings, and Dates
* Dynamic SQL
* Exceptions
* PL/SQL Collections and Records
* Automating Routine Tasks
* Oracle SQL Developer
* Analyzing and Improving Performance
* Using PL/SQL on the Web
* Java in the Database
* Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython
* Unit Testing With utPLSQL

I would recommend this book to any PL/SQL Developer / DBA as a worthwhile addition to their book collection.
1 of 2 people found the following review helpful
A very helpful book.. 27 Mar. 2011
By Frederick Couch - Published on
Format: Paperback Verified Purchase
This book has a lot of real world examples that are very useful. Even pieces of the solutions can be used elsewhere. I highly recommend this book to anyone who needs some real world examples to get going in PL/SQL
0 of 1 people found the following review helpful
Good book for getting up to speed quickly with Oracle PL/SQL! 17 Jan. 2011
By Michael B. Collins - Published on
Format: Paperback
This book was just what I needed as an experienced database developer but needing an update with Oracle database techniques. This book brought me up to speed with Oracle PL/SQL at warp speed. I like the format of giving the Problem, Solution, and an explanation of "how it works" for each solution. And with the experience of the authors and tech reviewer, I feel that I can trust that the solutions presented are the best possible approaches to use for each situation. That is invaluable for me and exactly what I needed.

I am still trying to decide if I like the new APress formatting with less space between lines, but I guess it doesn't bother me (like I thought it would the first time I saw it).
Great Buy !! 14 Feb. 2015
By Mohsin Qureshi - Published on
Format: Paperback Verified Purchase
Great Buy !!
Were these reviews helpful? Let us know