Live Webinar - Leveraging Red Hat OpenShift for a Multi-Cloud Strategy


Oracle Database 11g: Develop PL/SQL Program Units

Course Details
Code: D55831
Tuition (USD): $1,064.00 $1,010.80 • Self Paced
Generate a quote
Course Details
GSA (USD): $911.23 • Self Paced

This Oracle Database 11g: Develop PL/SQL Program Units course explores PL/SQL, the Procedural Language extension to SQL.

Learn To:

  • Create modularized applications using PL/SQL.
  • Develop, execute and manage PL/SQL stored program units, like procedures, functions, packages and database triggers.
  • Use Oracle-supplied packages, Dynamic SQL and the PL/SQL compiler.

Explore Design Considerations

Enrolling in this course will also help you develop an understanding of design considerations when coding using PL/SQL. Managing dependencies is also covered.

Skills Gained

  • Identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions
  • Recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code
  • Identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings
  • Identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies

Who Can Benefit

  • Application Developers
  • Database Administrators
  • Database Designers
  • Forms Developer
  • PL/SQL Developer
  • Technical Consultant


  • The learner should have experience and knowledge with SQL
  • Specifically the Oracle Database 11g: SQL Fundamentals I
  • Oracle Database 11g: SQL Fundamentals II

Course Details

Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL

  • Using Subprograms and Handling Exceptions
  • Using Functions, Creating Packages, and Debugging

Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL

  • Using Packages and Dynamic SQL
  • Coding Considerations in PL/SQL

Oracle Database 11g: Using Triggers, the PL/SQL Compiler, and Managing Code

  • Working with Triggers in PL/SQL
  • Using the PL/SQL Compiler and Managing Code

Oracle Database 11g: Managing PL/SQL Code and Dependencies

  • PL/SQL Code and Dependency Management