Free Downloads Oracle Database 12c PL/SQL Programming
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
Paperback: 1192 pages
Publisher: McGraw-Hill Education; 1 edition (February 14, 2014)
Language: English
ISBN-10: 0071812431
ISBN-13: 978-0071812436
Product Dimensions: 7.4 x 2.6 x 8.9 inches
Shipping Weight: 4.3 pounds (View shipping rates and policies)
Average Customer Review: 4.7 out of 5 stars See all reviews (18 customer reviews)
Best Sellers Rank: #114,976 in Books (See Top 100 in Books) #4 in Books > Computers & Technology > Databases & Big Data > Oracle #52 in Books > Computers & Technology > Databases & Big Data > SQL #117 in Books > Textbooks > Computer Science > Database Storage & Design
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 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.
I have been using this book to tutor students taking a PL/SQL class. I have found the book to be very helpful as the concepts are broken out well and the book correctly compartmentalizes various subject areas. I found the prototypes to be very helpful and made it easy to explain to students the syntax of everything from function and procedures to packages and classes. After listing the prototype at the beginning of a section the book does a great job at explaining in detail each clause of the prototype.I also found it very helpful that the beginning of the book contained a section about all the new features of 12c. In addition, the book elaborates on some new features and how implementation has improved from 12c from previous versions. In some cases when functionality has changed significantly from previous versions of oracle, and the author spends needed detail where possible on how the code would need to be implemented in older installations.Additionally I also found the appendixes to be VERY helpful, as it helps out with some remedial information on SQL in appendix B, as well as information about built-in packages and types that exist in 12c. Appendix H is particularly helpful as it contains an alphabetical list of all the reserved words built in the oracle 12c at initial set up, as well as a function that can query the database for all reserved words currently in the database. This is particularity helpful when you have created objects and there is a reserved word that you think should not be reserved.All in all, I found it to be one of the clearest textbooks I've used and the best book by Micheal McLaughlin that I have read so far. It is clear and concise, yet expands upon topics that need further detail.
SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Database 12c PL/SQL Programming Programming: Computer Programming for Beginners: Learn the Basics of Java, SQL & C++ - 3. Edition (Coding, C Programming, Java Programming, SQL Programming, JavaScript, Python, PHP) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Oracle Database 12c Oracle RMAN Backup and Recovery Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Oracle Database 11g SQL (Oracle Press) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) Oracle Database 12c For Beginners Oracle ASM 12c Pocket Reference Guide: Database Cloud Storage SQL Handbook: Learning The Basics Of SQL Programming (Computer Science Programming) (Computer Programming For Beginners) FORTRAN Programming success in a day:Beginners guide to fast, easy and efficient learning of FORTRAN programming (Fortran, Css, C++, C, C programming, ... Programming, MYSQL, SQL Programming) Oracle Database 10g PL/SQL Programming Programming #8:C Programming Success in a Day & Android Programming In a Day! (C Programming, C++programming, C++ programming language, Android , Android Programming, Android Games) Programming #57: C++ Programming Professional Made Easy & Android Programming in a Day (C++ Programming, C++ Language, C++for beginners, C++, Programming ... Programming, Android, C, C Programming)
