'
Oracle Advanced PL/SQL Developer Professional Guide
Overview of PL/SQL Programming Concepts
PL/SQL — the procedural aspect
PL/SQL development environments
Managing database dependencies
Reviewing Oracle-supplied packages
Understanding cursor structures
Collections—a comparative study
Manipulating collection elements
Using Advanced Interface Methods
Understanding external routines
Executing external C programs from PL/SQL
Executing Java programs from PL/SQL
Implementing VPD with Fine Grained Access Control
VPD implementation—outline and components
VPD implementation—demonstrations
Policy utilities—refresh and drop
Introduction to the LOB data types
Understanding the LOB data types
Working with the CLOB, BLOB, and BFILE data types
Migration from BasicFiles to SecureFiles
Compiling and Tuning to Improve Performance
Native and interpreted compilation techniques
Caching to Improve Performance
Configuring the database for the server result cache
Implementing the result cache in SQL
Implementing result cache in PL/SQL
Using SQL Developer to find coding information
Determining identifier types and usages
Profiling and Tracing PL/SQL Code
Safeguarding PL/SQL Code against SQL Injection Attacks
Immunizing SQL injection attacks