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