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