Oracle Database 12c PL/SQL Programming and over 2 million other books are available for Amazon Kindle . Learn more
  • RRP: £45.99
  • You Save: £16.10 (35%)
FREE Delivery in the UK.
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Oracle Database 12c PL/SQ... has been added to your Basket
Trade in your item
Get a £10.00
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 this image

Oracle Database 12c PL/SQL Programming Paperback – 1 Feb 2014

See all 4 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£25.65 £25.80
£29.89 FREE Delivery in the UK. Only 2 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Oracle Database 12c PL/SQL Programming + Oracle Database 12c PL/SQL Advanced Programming Techniques + Oracle Database 12c New Features
Price For All Three: £89.30

Buy the selected items together

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

Product details

  • Paperback: 1192 pages
  • Publisher: McGraw-Hill Osborne (1 Feb. 2014)
  • Language: English
  • ISBN-10: 0071812431
  • ISBN-13: 978-0071812436
  • Product Dimensions: 18.8 x 6.6 x 22.6 cm
  • Average Customer Review: 2.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 558,377 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Michael McLaughlin, Oracle ACE , is a professor at BYU – Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT Management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g & MySQL 5.6 Developer Handbook, Oracle Database 11g PL/SQL Programming Workbook, and many other books. Mr. McLaughlin worked at Oracle Corporation for more than eight years in Consulting, Development and Support. He left Oracle as the Senior Applications Upgrade Manager in E-Business Suite Release Engineering.

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

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

2.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

Format: Paperback
It is evident, from the first few pages, that Michael McLaughlin is an experienced lecturer/trainer, with an extensive knowledge of the subject. The content is delivered in a traditional teaching method, beginning with history and basics then progressively delving deeper into each subject area.
This book is presented in two parts. Part one is a content rich walk through PL/SQL features available in Oracle Database 12c. Part 2 is made up of Appendices offering an opportunity to explore PL/SQL features in greater depth. In part one, all topics are well supported, but not overwhelmed, by examples which clearly illustrate the features being described. More examples are available in the extensive appendices which expand on the topics covered in part one of this book. This layout makes the book significantly easier to read than many technical publications, avoiding the pitfalls of becoming bogged down in too much detail.
I believe that this book delivers value for both the novice and the more experienced developer. The novice will discover an excellent learning tool and the experienced developer a library of useful tips and examples to refer to. I would recommend Michael McLaughlin’s book to all who want to learn PL/SQL or need a handy PL/SQL reference 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
Format: Paperback Verified Purchase
The book is full of inaccuracies, several of the examples are plain wrong. As an example the ORDER member function for SQL OBJECT types is named and described as 'equals' (returning 0 or 1) even though it's definition according to the online Oracle documentation it is an less/equal/greater function that should return -1/0/1.

I have the feeling that the author is more of a database expert than a programmer, which is rather unfortunate when the topic is in fact a programming language.
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) 12 reviews
9 of 9 people found the following review helpful
An amazing learning tool for Oracle 12c 9 Feb. 2014
By Carlie Hendrick - Published on
Format: Paperback
To put it quite simply, this book is fantastic. Each chapter is rich with content and offers numerous amounts of coding examples that help paint a vivid picture of how you would impliment the code in your own day to day experiences with 12c. What really won me over with this book wasn't the fine detail within the chapters, but what was outside the chapters. More than HALF of this book is made up of Appendices that go into an amazing amount of detail for the code examples in each of the chapters. This is particularly useful in two different ways.

The first being that it helps each chapter become much easier to follow and understand, and that the chapter doesn't become bogged down by creating too much attention on one example. Instead, each chapter discusses a concept with detail, and then refers you to the Appendix for further in depth detail. For me personally, this really made it easier for me to read through each chapter and create an understanding on all the material, and then I could reference the Appendix for further detail if needed.

The second being that if you struggle with a concept or want to learn more about a particular subject within any of the chapters, you can reference the Appendix and have more than enough material to become extremely knowledgable on the subject matter. One particular thing I really enjoyed from personal experience, Is I had referenced the Appendix for "Security Hardening". I was suprised to find an amazing amount of information, one bit of information in particular teaches you how to use a packet sniffer tool, called wireshark, to detect and find user login credentials as well as how to protect yourself from those who are trying to use this method to gain access to your own credentials!

This book was much easier to read than Michael McLaughlins previous "Oracle Database 11g & MySQL 5.6 Developer Handbook". While still an amazing book to introduce MySQL and Oracle databases to a SQL newcomer, it was not as easy a read due to jumping between multiple databases and it felt the chapters had a few too many examples. None of which is an issue in this book in any way, shape, or form.

I really enjoyed this book, and would absolutely recommend it to anyone looking for an in depth and hands on experience with Oracle 12c
7 of 7 people found the following review helpful
Crisp, clean, concise and highly-organized. 27 May 2014
By Mike Kemp - Published on
Format: Paperback
This will be the third book I have read out of several of Michael's books on Oracle.

I get the same feeling from reviewing this book that I get when writing a procedure or package to fill a Technical Requirement and, after spending some time on it, the procedure or package all comes together as neat, clean, efficient and complete.

The striking thing about this book, for me, is its precise focus on subject matter. By that I mean that if a section is entitled, "Lexical Units", that's exactly what it's about, with no superfluous information or digressions found there. I, personally and in various technical documents I have written for work, have found that this precise focus is an easy thing to conceive of and aspire to, and a difficult thing to accomplish in a project of any scale. The difficulty comes in trying to strike that balance between being thorough and being focused and concise.

The way Michael accomplished this in this book is by "back-loading" the book with massive and great appendixes on the following subjects: 1) Oracle Database Primer, 2) SQL Primer, 3) SQL Built-in Functions, 4) PL/SQL Built-in Packages and Types, 5) Regular Expression Primer, 6) Wrapping PL/SQL Code Primer, 7) PL/SQL Hierarchical Profiler Primer and 8) PL/SQL Reserved Words and Keywords.

Putting all of this deep technical knowledge at your fingertips, without having to cloud a given chapter or section with it, when the chapter or section describes a more specific but related topic, gives this book its crisp and clean quality of reading or reference.

This book is worth the purchase price for either the "SQL Primer" appendix (almost 200 pages) or the "PL/SQL Built-in Packages and Types" appendix alone. Obviously, all of the appendixes are valuable depending upon your needs at any given point in time, but in my career, my intense focus on PL/SQL combined with the inherent differences in concept and syntax paradigms between PL/SQL and SQL, have caused me to overlook a lot of the inherent power available in SQL, and my intense focus on "build, build, build", I think, has caused me to overlook much of the out-of-the-box power available in the Built-in Packages and Types.

In particular, the SQL appendix is particularly thorough, crisp and clear covering many sub-subject areas, among which the following are found: 1) History of SQL, 2) SQL Data Types, 3) DDL, DML, Transaction Management, 4) ACID compliance and how the Oracle database achieves it, 5) Managing Nested Tables and VArrays, 6) Advanced DML such as multiple-table Insert statements, Updates and Deletes using correlated subqueries and the Merge statement, 7) Managing large objects (Clob, Blob, etc.), 8) Overloading, 9) Object Types.

Regardless of your place on the Oracle SQL or PL/SQL expertise scale, I am confident you will find this book an invaluable reference to help you accomplish your programming goals due to its crisp, clean, organized and thorough coverage of the Oracle PL/SQL subject matter, along with other related information contained in its voluminous appendixes.
6 of 6 people found the following review helpful
Learning and Reference 20 April 2014
By Matthew S. Mason - Published on
Format: Paperback
This book is both easy to use if you are a new comer to PL/SQL or someone that has been using it for awhile. The layout of the book is easy to bounce around in as a reference book should be and at the same time uses a language and flow from start to finish that makes it a great tool to learn PL/SQL from. I am grateful to have this book in my Library of Database literature. I own it both in physical and eBook format. I have the eBook for the ease of carrying it around but prefer the Physical book when I am at my desk.
4 of 4 people found the following review helpful
Very handy to have nearby. 11 May 2014
By Devin - Published on
Format: Paperback Verified Purchase
Oracle Database 12c PL/SQL Programming has met all of my expectations and more. There are plenty of great examples throughout the book that spark imagination and creativity. When you're wondering how something you've just read about works, you don't need to look vary hard to find an example to go with it. At the end of the chapters there are great questions to quiz yourself on as well. I have enjoyed, and continue to enjoy this book.
3 of 3 people found the following review helpful
Michael McLaughlin... Need I say more? 26 Mar. 2014
By Emile A. Khoury - Published on
Format: Kindle Edition Verified Purchase
Michael McLaughlin... Need I say more?

I'm a current student of Michael McLaughlin and love his way of teaching and his willingness to update his books to comply with industry standards and innovation. Recommended to all who have passion in learning PL/SQL programming and would like to learn it from the basic level to master.
Were these reviews helpful? Let us know