Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

<h4>Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, <span style="white-space:pre"></span>authenticity, or access to any online entitlements included with the product.</h4><h4>Master Oracle Database 12<i>c</i> PL/SQL Application Development</h4><p>Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, <i>Oracle Database 12c PL/SQL Programming</i> 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.</p><ul><li>Explore new SQL and PL/SQL features in Oracle Database 12<i>c</i> </li><li>Build control structures, cursors, and loop statements</li><li>Work with collections, varrays, tables, and associative array collections </li><li>Locate and repair errors and employ exception handlers</li><li>Execute black box, white box, and integration tests</li><li>Configure and manage stored packages and libraries</li><li>Handle security with authentication and encryption</li><li>Use LOBs to store text and multimedia content</li><li>Write and implement PL/SQL and Java triggers</li><li>Extend functionality using dynamic SQL statements</li><li>Understand object types, nested tables, and unnesting queries</li></ul>