Use conditional compilation to customize the functionality in an PL/SQL application without removing any source code
Create and use stored procedures and functions
Design and use PL/SQL packages to group and contain related constructs
Create overloaded package sub-programs for more flexibility
Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
Write dynamic SQL for more coding flexibility
Describe the features and syntax of PL/SQL
Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Manage dependencies between PL/SQL sub-programs
Handle runtime errors
Describe stored procedures and functions
Design PL/SQL code for predefined data types, local sub-programs, additional programs and standardized constants and exceptions
Create triggers to solve business challenges
Design PL/SQL anonymous block that execute efficiently

Tune PL/SQL code
Categorize and explain various types of SQL injection attacks
Apply coding standards to eliminate SQL injection vulnerabilities
Create sub-types based on existing types for an application
Create and use collections
Execute external C programs from PL/SQL
Execute Java programs from PL/SQL
Describe the process of fine-grained access control
Create and maintain LOB data types
Use the DBMS_LOB PL/SQL package to control LOBs
Describe SecureFile LOB features
Identify guidelines for cursor design
Enable SecureFile LOB de-duplication, compression, and encryption
Improve memory usage by caching SQL result sets
Set up PL/SQL functions to use PL/SQL result caching
Profile PL/SQL applications