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 mobile phone number.

Expert PL/SQL Practices: for Oracle Developers and DBAs 1st ed. Edition

3.8 out of 5 stars 6 customer reviews
ISBN-13: 978-1430234852
ISBN-10: 1430234857
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.
Trade in your item
Get a $2.00
Gift Card.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$27.99 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$47.59 On clicking this link, a new layer will be open
More Buying Choices
25 New from $40.48 24 Used from $24.00
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get a FREE Amazon Echo with SAT prep
Prep whenever you want, for as long as you need with The Princeton Review. Learn more
$47.59 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Editorial Reviews

About the Author

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006) and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal). Michael is an Oracle ACE, a frequent presenter at various regional and national Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the President of Ukraine, a Master of Science degree in Information Systems, and a diploma with honors from the Kiev National University of Economics.

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Paperback: 512 pages
  • Publisher: Apress; 1st ed. edition (July 25, 2011)
  • Language: English
  • ISBN-10: 1430234857
  • ISBN-13: 978-1430234852
  • Product Dimensions: 7.5 x 1.2 x 9.2 inches
  • Shipping Weight: 2.4 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #1,733,108 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback
I was a little bit puzzled when I got this book: who is the author? There are 15 of them! After reading it, I now believe it is a very good idea to combine knowledge from multiple experts into a single book, especially for a technical book. I would like to see more of these kinds of books coming.

The writers of this book are all very active in the Oracle community, most are authors, Oracle ACE, members of the OakTable network, etc. I actually met a few of them at seminars and user group activities. One of them, Arup Nanda, was once my RAC class instructor, and I've always been impressed by his ability to explain complicated issues in a simple and interesting way. In this book, he discussed dependencies and invalidations with the same clear logic.

The book has 15 chapters, with each author contributing one. Every chapter has a brief summary. Almost all of them go deeply into the topic using very good sample codes, traces, and tkprof output to prove their points.

You may read it as a book focusing on the newest and most powerful PL/SQL features, or you can treat it as 15 top level technical articles - each concentrates on a specific PL/SQL field and digs deeply into it. You'll learn the best practices from their expertise; real experiences and lessons. You can also gain lots of TTTs: Tips, Tricks and Traps to avoid. Many new data dictionary views mentioned by the authors are also very useful.

Based on the needs of my current work, I went through some chapters in close detail, and browsed others for future reference. The book touches the most recent Oracle version, including many new features of 11gR2.

This book is not for beginners. You will need some PL/SQL background to start with.
Read more ›
1 Comment 8 people found this helpful. 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
This is a MUST READ book for all DBAs & Developers. This is like having 30min 1-on-1 session with 15 subject matter experts.

As a DBA I always face challenges when explaining to developers the DOs & DONTs in SQL & PL/SQL.
The reasons being -
1. PL/SQL & SQL (oracle) has evolved a lot in last few years sometimes we don't keep track of new features.
2. Most of the developers practice either Java & or C++,C# religion, hence they look at PL/SQL with prejudiced view.

Even DBAs also get away with their jobs using their ancient knowledge about PL/SQL from 7.3 era.

Some of us do try to keep our knowledge up-to-date with white papers/articles, and try to make use of it but not effectively.

This book explains developers how/when to use SQL vs PL/SQL effectively. It explains the coding styles/standards & their use. It not only explains DOs, but it explains DONTs as well.

DBAs - One of the biggest challenge we normally have to deal with is code review...... making sure that it is not violating standards, compliance guideline and that we get it right when it is ready for implementation.... This book has tips to develop automated scripts/queries... just by running these we will be able to catch most of the violations.

Developers - Even though most of them have knowledge about the PL/SQL objects & standard SQLs, but one tend to loose the touch as
- They get pressured by deadlines
- Busy gaining business knowledge
- Keeping up with new features of their native programming languages.

This book will provide you in-depth knowledge on using SQL and or PL/SQL "effectively".....Please note this book is not for beginners as it assumes you know the syntax & feature.
Comment 4 people found this helpful. 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
This is a book written by 15 of the top PL/SQL experts and each of them gets to take you deep into their chosen subject matter. Books like this are great in the fact that you get in-depth coverage of the material being presented by someone who is passionate about the subject.

The authors show you what you can do to help make your code better for not only your benefit, but for the benefit of those that will come later and have to maintain your code.

Here is a brief description of some of my favorite chapters:

Chapter 1 shows why using PL/SQL might not be the best choice in a given situation. If you can get the job done strictly with SQL, then PL/SQL just adds unnecessary complexity and resource use. If you're coming from a programming background and haven't done much database work, this chapter would be a great reference for you.

Chapter 2 covers dynamic SQL and the pros and cons of working with it. In my experience this technique is underused, and too many people try to make a single general purpose (static) query that is hard to tune and work with. When done right, dynamic SQL can offer significant performance benefits without introducing complexity or security issues.

Chapter 7 talks about knowing your code. This is not only the code you write, but the code you must maintain. When your manager comes and asks you to make a change to some code, you need to know how that data is being used, what calls that code, and how the change will affect anything using it downstream. By putting the practices mentioned here into use, you will make it easier on yourself when making those changes and will have the confidence to know where and how to test your changes to verify nothing broke with the changes made.
Read more ›
2 Comments 5 people found this helpful. 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

Expert PL/SQL Practices: for Oracle Developers and DBAs
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: Expert PL/SQL Practices: for Oracle Developers and DBAs