About this item

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



About the Author

Michael McLaughlin

I finished writing the Oracle Database 12c PL/SQL Advanced Programming Techniques book, and it'll be available for purchase in November. I also recently finished Oracle Database 12c Programming book. I'm an Oracle ACE and veteran of Oracle technologies (20 years) . I'm the author or co-author of ten Oracle Press books.

I teach database technology and systems analysis and design in the Computer Information Technology Department at BYU - Idaho. I also worked at Oracle Corporation in consulting, development, and support. I'm the inventor of the ATOMS transaction architecture (U.S. Patents #7,206,805 and #7,290,056) . The patents are assigned to Oracle.



Read Next Recommendation

Report incorrect product information.