Oracle Database 12c PL/SQL Programming e-bog

Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, 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 12cBuild control structures, cursors, and loop statementsWork with collections, varrays, tables, and associative array collectionsLocate and repair errors and employ exception handlersExecute black box, white box, and integration testsConfigure and manage stored packages and librariesHandle security with authentication and encryptionUse LOBs to store text and multimedia contentWrite and implement PL/SQL and Java triggersExtend functionality using dynamic SQL statementsUnderstand object types, nested tables, and unnesting queries