Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Oracle Database 12c PL/SQL Programming [Kindle Edition]

Michael McLaughlin
3.0 out of 5 stars  See all reviews (3 customer reviews)

Print List Price: £45.99
Kindle Price: £28.40 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £17.59 (38%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £28.40  
Paperback £29.89  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Master Oracle Database 12c PL/SQL Application Development

Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.

  • Explore new SQL and PL/SQL features in Oracle Database 12c
  • Build control structures, cursors, and loop statements
  • Work with collections, varrays, tables, and associative array collections
  • Locate and repair errors and employ exception handlers
  • Execute black box, white box, and integration tests
  • Configure and manage stored packages and libraries
  • Handle security with authentication and encryption
  • Use LOBs to store text and multimedia content
  • Write and implement PL/SQL and Java triggers
  • Extend functionality using dynamic SQL statements
  • Understand object types, nested tables, and unnesting queries

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

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.

Product details

  • Format: Kindle Edition
  • File Size: 77717 KB
  • Print Length: 1192 pages
  • Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits
  • Publisher: McGraw-Hill Education; 1 edition (7 Feb. 2014)
  • Sold by: Amazon Media EU S.ą r.l.
  • Language: English
  • ASIN: B00HSO0X0S
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • : Not Enabled
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: #284,530 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

5 star
3 star
2 star
3.0 out of 5 stars
3.0 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
By Andrew
This is a hefty treatise on PL/SQL in the 12c database nearly 1200 pages long. It is well put together and written in a very friendly and readable style without being belittling.
The book is broken down into three parts:
Part 1 covers the history and origins of PL/SQL, new features for 12c, the basics of PL/SQL programming, fundamentals of the PL/SQL language, controlling flow, dealing with collections, and error and exception management.
Part 2 covers programming with functions and procedures, packages, dealing with Oracle's implementations of large objects, objects, triggers and dynamic SQL
Part 3 is a set of appendices that spans almost half of the book and includes a primer on the database, its architecture, and tools useful to the developer like tuning and tracing. It also has a primer on SQL, new built-in packages, a primer on dealing with regular expressions, wrapping PL/SQL, the hierarchical profile primer and finally an alphabetical reference of reserved words and keywords.

Each chapter provides an explanation of the content under discussion, example code with the related output, reviews after each section and self-check questions of which some are True/False and others are multiple choice. The answers are provided in the final appendix and are broken down chapter by chapter.

To me one of the measures of the structure of a good reference book is how comprehensive the index is. In this case it is 54 pages long and the eBook version includes clickable page numbers, a small feature but very handy in a book of this size (why isn't this done more in other books??).

Other reviewers have cited inaccuracies in some of the syntax.
Read more ›
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Recommended learning and reference tool 25 Mar. 2015
By Joolz
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?
0 of 1 people found the following review helpful
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?
Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  14 reviews
10 of 10 people found the following review helpful
5.0 out of 5 stars An amazing learning tool for Oracle 12c 9 Feb. 2014
By Carlie Hendrick - Published on
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
8 of 8 people found the following review helpful
5.0 out of 5 stars Crisp, clean, concise and highly-organized. 27 May 2014
By Mike Kemp - Published on
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.
7 of 7 people found the following review helpful
5.0 out of 5 stars Learning and Reference 20 April 2014
By Matthew S. Mason - Published on
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.
5 of 5 people found the following review helpful
5.0 out of 5 stars Very handy to have nearby. 11 May 2014
By Devin Lindsay - 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
5.0 out of 5 stars 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
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category