Oracle Database 11g PL/SQL Programming (Oracle Press) and over 2 million other books are available for Amazon Kindle . Learn more
FREE Delivery in the UK.
Only 8 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Oracle Database 11g PL/SQ... has been added to your Basket
Used: Very Good | Details
Sold by UK Media Source
Condition: Used: Very Good
Trade in your item
Get a £4.45
Gift Card.
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 Database 11g PL/SQL Programming (Oracle Press) Paperback – 1 May 2008

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£21.85 £17.24

There is a newer edition of this item:

£39.99 FREE Delivery in the UK. Only 8 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Oracle Database 11g PL/SQL Programming (Oracle Press) + Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL: Oracle Certification Prep
Price For Both: £48.98

Buy the selected items together

Trade In this Item for up to £4.45
Trade in Oracle Database 11g PL/SQL Programming (Oracle Press) for an Amazon Gift Card of up to £4.45, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 835 pages
  • Publisher: McGraw-Hill Osborne (1 May 2008)
  • Language: English
  • ISBN-10: 0071494456
  • ISBN-13: 978-0071494458
  • Product Dimensions: 19.3 x 4.3 x 22.6 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 651,955 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

Michael McLaughlin is a professor of Computer Information Technology at BYU-Idaho, the author of Oracle Database 10g Express Edition PHP Web Programming, and coauthor of the previous edition of this book. He has been working with PL/SQL since release 1.

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

Customer Reviews

3.0 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

4 of 4 people found the following review helpful By The King on 6 Jun 2009
Format: Paperback
I'm using this as a revision aid for exam 1Z0-147 which I'm taking in a week's time. I'm still reading it, and have found a lot of the content useful so far, but whilst struggling through chapter 7 (collections) I felt compelled to take a second to complain about how badly written and just plain wrong some of it is. There's a lot of repetition, and in places it looks like text or code examples are copied-and-pasted and not changed to reflect their new subject.
"Nested Tables"
"Like varrays, nested tables are single-dimensional structures of Oracle 11g SQL or PL/SQL datatypes. You can use them table [sic], record, and object definitions and access them in SQL and PL/SQL. You can also use nested tables in table, record, and object definitions. They are accessible in both SQL and PL/SQL."

I had a look on the Osborne web site but couldn't find any sort of errata anywhere.
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
Format: Paperback Verified Purchase
I bought this book along with Oracle PL/SQL Programming - Paperback (22 Aug 2005) by Steven Feuerstein and Bill Pribyl. I ended up returning this one. There is nothing drastically wrong with it. It's just that I am new to plsql and wanted something good to use as a tutorial. I found this book very, very dry. It is really a reference work rather than an introduction. I found the other book had a much stronger narrative voice and was easier to read. Also it contained much more information about how to use up SqlPlus, etc, which this book does not contain at all.
As a reference it seemed pretty comprehensive though.
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
By lopesr on 16 Oct 2010
Format: Paperback
The contents of the book and the way of explaining is very good.

But there are some errors (copy-paste in different contexts for exemple). Because of this, I'm giving 4 stars.
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
Format: Paperback
I read earlier verion(9i) of PL/SQL Oracle Press book and found much better than this one. It will not recommend this book to anybody. Language concepts like overloading etc. not explained in detail. Also book language to explain concept is not well organized
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) 25 reviews
15 of 18 people found the following review helpful
Mike Farmer 3 April 2008
By Michael Farmer - Published on
Format: Paperback
Michael McLaughlin has delivered the most comprehensive book on PL/SQL on the market. No matter where you are, novice or master, you will find this book helpful. The book is loaded with practical, working examples and detailed descriptions that will help you from getting lost. Even the most complex topics are covered thoroughly and comprehensively in a way that makes them feel simple. Even if you are not on 11g yet, you need to buy this book. It's not only a great reference, but an interesting and captivating read that will give you ideas and understanding which will help in any project.

Most of all, this book reveals the power of PL/SQL as a viable and fully-featured programming language. It covers complex subjects such as Object Oriented Programming and utilizing Large Objects (LOBS) with striking detail. It also contains a primer on using PHP and Java with PL/SQL! You'll also find a revealing discussion on using Functions, Procedures, and Packages that enhance understanding in a way that no other book does. Other books teach you the "how", this book covers the "what" and the "why" so that you not only can write the code, but you understand everything that it is doing.

I would highly recommend this book to anyone that uses PL/SQL no matter your current skill level. There's great content for everyone.
17 of 21 people found the following review helpful
The best book to understand Oracle's PL/SQL and how to use it effectively. 25 May 2008
By Ron Soltani - Published on
Format: Paperback
This is one of the best technical books I have read. It makes PL/SQL easy to learn for the beginners and it is so detailed that very experienced users will find it extremely useful. It covers the usage of PL/SQL with many different types of applications such as JAVA, XML, PHP, etc. I have recommended very few language books in my time, because, I have found them to be written with the writer's logic as to how the writer thinks the code would be better executed. However this is the first book that I have seen that is written logically based on how the language would be better used to efficiently interact with the database. In short, I give this book my highest recommendation. I would like to congratulate Michael on writing such a great book.
4 of 4 people found the following review helpful
GREAT book!! 30 Oct 2009
By Mike Kemp - Published on
Format: Paperback
This is the first technical/computing book that I have ever read cover to cover.
In fact I read this book cover to cover with multiple iterations of chapters that were difficult for me (e.g., Chapter 6 Functions and Procedures, Chapter 8 Large Objects, Chapter 13, External Procedures, Chapter 14 Object Types and the PHP/Java Primers in Appendices C and D, respectively).
I have been a PL/SQL Developer for over 6 years.
I thought I was doing pretty well but it turns out I was doing a limited number of things in my development experience over and over again. The ease with which I was writing functions and procedures, organizing the same in packages and utilizing a very few of the more advanced features like BULK COLLECT and BULK UPDATE was a deceptive set of convenient facts: Thanks to this book I now know how much I didn't know and I have a more than vague feeling that even now my ship is still relatively close to shore. There is much more the the "sea of PL/SQL", if you'll allow me that much of a poetic license!
I was particularly surprised to find out how little I knew about Oracle functions after having written so many over the years. Pipelined functions? I had never heard of them! Creation options? Eh...those either! I did not know you could used mixed notation to make a call to a procedure with multiple parameters.
The book has some typographical/copy and paste-type issues which threw me off in the beginning. It's likely not the book as much as it is my personality: I'm a classically trained musician from another life (a MUCH younger life) so you can imagine that I might be predisposed to being a stickler for details.
In the end, I finished this book because it was thorough, clear, deep (the way I like it!) and had great continuity (I am easily confused so this is important to me!).
One of the most frustrating parts of reading techinical books for me has been when the book begins an example, abandons the example and then starts a new one without the author saying something to the effect of, "In this *new* example..." or "I'll use a different example to demonstrate...".
The examples in this book are so continuous that those statements are never even needed.
Mr. McLaughlin very courteously (in my opinion) allows readers to benefit from a well-thought plan (apparently!) of moving smoothly from one technical issue to the next by extending an already developed example. I find this feature to be very reassuring and conducive to quick learning. I mean, code is hard enough to read by itself; much more so when the context of the code switches from page to page or randomly 2,3,4 or 5 pages into an issue.
The way Mr. McLaughlin makes use of code examples in this book is very helpful, too, because it allows the reader to better understand how one technical issue is related to another. As an example: how to use Virtual Directories is included in the chapter on Large Objects. Now, one wouldn't necessarily *only* use Virtual Directories with Large Objects, but it does make sense, and having the subject placed there helps me understand the most common (I assume) real-world application of Virtual Directories.
I would say that this has been an excellent resource for me as a cover-to-cover read and I have already used it as a reference manual so I am sure it works well in that way also.
I hope your experience with this book is as good as mine has been.
Many congratulations and my deepest appreciation to this author!
My first technical book ever!
This is a huge accomplishment for me (and the author!)!!.
10 of 13 people found the following review helpful
Oracle Database 11g PL/SQL Programming by Michael McLaughlin. New York, 2008 by McGraw-Hill Companies, Inc. 20 Dec 2008
By Trish McCormick - Published on
Format: Paperback
Oracle Database 11g PL/SQL Programming by Michael McLaughlin. New York, 2008 by McGraw-Hill Companies, Inc.

As business processes and problems rely more and more on reporting and data analysis from Oracle databases, there is an increasing need for personnel that have a working knowledge of the PL/SQL language. In this book, the author intends to teach those just beginning to learn PL/SQL the basic concepts through some of the more challenging capabilities of the language. McLaughlin does quite a respectable job of accomplishing this difficult task.

Throughout the book a reader is supplied with example code that works as prescribed, personal experiences illustrating code hazards and successes for various applications, figures demonstrating how code works in complex situations, appendices abundant with relevant information for easy reference and finally even a bit of humor here and there. Although the intended audience is new users, experienced PL/SQL programmers would benefit as new features in 11g are explained and clarified with code examples.

There are many ways to present methods for learning programming languages, ranging from brief explanations with code snippets to extraordinary or mind numbing details with few or no examples. In the former case many gaps exist and a reader is usually left without a clue as to how to use the language at all, let alone effectively. And in the latter case, by the time a reader finishes a paragraph she is left wondering how to use and apply the material in a realistic scenario. In this book McLaughlin balances the two extremes to provide a consistent method useful for both new and experienced programmers. Clearly and succinctly he presents a topic and then provides an easily understandable example. However, for some of the more complex concepts presented in Part III of the book the PL/SQL novice should be prepared to spend some time reading and practicing coding. There are a few cases where a concept is presented briefly in early chapters without a complete coding example and then in later chapters details are revealed in more advanced situations. In such cases a reader is expected to have the memory and insight to integrate this information to fully appreciate the code example. I spotted such a condition while reading the technique of overloading a function in Chapter 9 Packages. I was looking forward to an example but one did not exist. Later while working in Chapter 15 Java Libraries, to my surprise found that complete code example in HelloWorld2.sql for an overloaded procedure. This minor oversight would not faze an experienced programmer and hopefully should not prove too frustrating for a new user either. It could serve as a discovery or maybe was intended as a self-check on how well previous chapters were understood.

In summary, whether you are new to Oracle Corporation's PL/SQLÒ or an experienced PL/SQL programmer, this book provides valuable direction and advice for learning the language. It introduces and details new features for 11g and provides readers the opportunity to expand their repertoire of programming tools.
3 of 3 people found the following review helpful
PL/SQL 11g book 31 July 2013
By Robert Pyles - Published on
Format: Paperback Verified Purchase
GREAT!! GREAT!! GREAT!! The book explains how-to that is understandable and well-worded, There are plenty of examples that can be utilized for application.
Were these reviews helpful? Let us know