Programming Books C Java PHP Python Learn more Browse Programming Books
Mastering Oracle PL/SQL: Practical Solutions and over one million other books are available for Amazon Kindle. Learn more
Buy New
$36.22
Qty:1
  • List Price: $49.99
  • Save: $13.77 (28%)
In stock but may require an extra 1-2 days to process.
Ships from and sold by Amazon.com.
Gift-wrap available.
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
Have one to sell? Sell on Amazon
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

Mastering Oracle PL/SQL: Practical Solutions Paperback – January 8, 2004


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$36.22
$19.99 $7.03
Best%20Books%20of%202014

Frequently Bought Together

Mastering Oracle PL/SQL: Practical Solutions + Oracle PL/SQL Best Practices
Price for both: $57.93

One of these items ships sooner than the other.

Buy the selected items together
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Oaktable Series
  • Paperback: 648 pages
  • Publisher: Apress; 2004 edition (January 8, 2004)
  • Language: English
  • ISBN-10: 1590592174
  • ISBN-13: 978-1590592175
  • Product Dimensions: 7.5 x 1.5 x 9.2 inches
  • Shipping Weight: 2.6 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: #1,394,595 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Christopher Beck has a bachelor's degree in computer science from Rutgers University and has been working in the technology industry for 11 years. Starting off as a junior Ada software developer for a government systems integrator, he has spent the past 7 years with Oracle, most recently as a principal technologist. He specializes in core database technologies and web application development. Beck is also a cocreator of Oracle Portal, a commercial product that began as, in Beck's own words, a "science project," then became known as WebView.

Customer Reviews

4.8 out of 5 stars
5 star
7
4 star
2
3 star
0
2 star
0
1 star
0
See all 9 customer reviews
This is great book, It has a lots of example and explained really well.
Iqbal Singh
With 15 years experience in Oracle as DBA and developer, I wrote a lot of packages and found in this book true advices and practical solutions, wich sound good to me.
Trendy73
Probably more a information and guidence book rather than a reference book.
Chris Barnes

Most Helpful Customer Reviews

24 of 24 people found the following review helpful By Odessey Talbot on October 20, 2004
Format: Paperback
I've had this book for a couple of months now. I've been waiting to finish it before writing a review, but it doesn't look like I'll be finished with it any time soon mostly because I'm using it as a reference book instead of reading it from front to back.

Clearly the book wasn't written as a reference book. Just look up almost any topic in the index and you'll find a number of entries scattered all over the place. Pipe-lined functions, for example, are written about in 4 (four) separate chapters! But the index is good and the material isn't redundant. The reason for this strange structure, I think, is as follows:

The book is divided into two equal length sections. The first half deals in general with PL/SQL strategies and techniques: how to check your code for efficiency, why code should be in packages, how to use cursors, cursor variables, cursor expressions, anchored data types and collections. The second half of the book re-visits most of the same topics in an application centric way (often using PL/SQL supplied packages). It's natural that some of the same techniques and strategies will be re-used and there will be some overlap in the application-oriented chapters.

Sometimes though, the repetition is weird: both the trigger chapter and the security chapter describe a logon trigger that's designed to prevent an ODBC user from accessing the database. The security chapter discusses the data base object grants that are necessary for the trigger to work while the trigger chapter omits all this. The trigger chapter discusses the security risk with the trigger, how a user can often rename the desktop application and bypass the trigger's intent (and purpose) while the security chapter doesn't mention that problem at all.
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
7 of 7 people found the following review helpful By Doroszlai Attila on March 9, 2005
Format: Paperback
The book takes a bottom-up approach: the first part shows useful coding and optimizing techniques, while the second one gives real world applications and tips on program design.

I have two minor complaints, however:

Most chapters assume at least a good knowledge of PL/SQL and build on that, which I think is fair for a book titled "Mastering ...". On the other hand, two of the chapters (Triggers especially, and PL/SQL Debugging to a degree) take a different approach and start from the beginning, explaining the basics, too. It may be just me, but I think those pages are wasted.

Furthermore, there is a certain amount of overlap with Tom Kyte's Expert One-on-One Oracle, also from Apress.
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
5 of 5 people found the following review helpful By Trendy73 on September 5, 2005
Format: Paperback
With 15 years experience in Oracle as DBA and developer, I wrote a lot of packages and found in this book true advices and practical solutions, wich sound good to me. The best feature is that you can experiment all the code found in it and see by yourself the advantage of using the way proposed by McDonald. I like these books where autors breaks some common ideas ans show by "A + B" that the right solution is not the most common. A real useful book written by a true professional.
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
8 of 10 people found the following review helpful By Alberto Dell'era on April 2, 2004
Format: Paperback
Here's he first thing that you will notice when you read this book: it is extremely easy to follow, with every explanation leading naturally to the next one, in a seamless way. Now I understand why the Author's presentations at top-notch Oracle events are always "sold-out" - excellent knowledge mixed with excellent presentation skills is rarely found in the same person, but for sure Connor McDonald is an example of this rare breed. I may say that I "drank" more than "read" the book.
The contents, that goes without saying, are really interesting, and I've already used the improved knowledge and new facts that I've got from the book for my code and designs. Most importantly, I know, given the Author's reputation and method (always try things out and then provide a test case), that what's in the book is correct and works - which, sadly, does not apply for too many books about Oracle out there.
The book now is included in my "gold quality" bookshelf. Since this bookshelf is composed exclusively by books authored by Thomas Kyte, Jonathan Lewis, Steve Adams, Cary Millsap, James Morle, and now Connor McDonald, who are members of the OakTable Network (which i've nicknamed the "Oracle Scientist Club", since in essence, the reason why they are so succesfull it's that they follow the aforementioned method in investigating Oracle), I'm really sure that the "OakTable Press Series" is not to be missed, and I won't miss for sure. Great!
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 Satish Mehta on October 22, 2005
Format: Paperback
The book is good but many solutions are not tested fully so its not that they can be cut and pasted directly out of the book. you may have to troubleshoot many of them. Otherwise a real good book.
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

What Other Items Do Customers Buy After Viewing This Item?