Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

<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>