·         Application Developers

·         Database Administrators

·         Developers

·         PL/SQL Developers

·         Portal Developers

·         Systems Analysts

·         Technical Consultants

·         Create overloaded package sub-programmers for more flexibility

·         Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code

·         Make triggers to resolve business issues and challenges

·         Write dynamic SQL for more coding flexibility

·         Design PL/SQL packages to group related constructs

·         Construct and debug stored procedures and functionalities

·         Design PL/SQL anonymous blocks that work effectively

·         Use the Oracle supplied PL/SQL packages to produce screen output, file output and mail output

·         Describe the features and syntax of PL/SQL

·         Manage dependencies between PL/SQL sub-programmer

·         Use PL/SQL programming constructs and conditionally manage code flow including loops, control structures, and explicit cursors

·         Deal with runtime errors

•     Overview

•    Declare Pl/SQL identifiers

•    Use a Write executable statements

•   Interacting with the oracle server

•   Control servers

•     Composite data types

•   Explicit cursors

•     Exception handling

•   Stored Procedures

•  Stored functions and debugging sub programmer

•     Packages

•     Deploying packages

•    Implement Oracle-Supplied Packages in Application Development

•     Dynamic SQL

•   Design considerations for PL/SQL code

•    Triggers

•     Creating Compound, DDL, and Event Database Triggers

•     Manage Dependencies