Course Overview:

In this course, students learn how to use the advanced features of PL/SQL in order to design & tune PL/SQL to interface with the database & other applications in the most efficient manner.  Using advanced features of program design, packages, cursors & collections, students learn how to write powerful PL/SQL programs.

Attendees to OR-422: Oracle 11g: Advanced Oracle PL/SQL will receive TechNow approved course materials and expert instruction.


No Events

Duration: 2 Days

Course Objectives:

  • PL/SQL Programming Concepts Review
  • Identify PL/SQL Block Structure
  • Procedures, Functions, Packages
  • Cursors
  • Exceptions
  • Design Considerations
  • Cursor Design
  • Describe Cursor Variables
  • Pass Cursor Variables as Program Parameters
  • Compare Cursor Variables to Static Cursors
  • Program Overloading
  • Overloading Concepts
  • Writing an Overloaded Program
  • Oracle Supplied Packages
  • Common Supplied Packages
  • Using Supplied Packages
  • Collections
  • Describe & Use Nested Tables
  • Describe & Use Varrays
  • Describe & Use Associative Arrays
  • Describe & Use String Indexed Collections
  • Describe & Use Nested Collections
  • Write PL/SQL Programs That Use Collections
  • Performance & Tuning
  • Tune PL/SQL Code
  • Write Smaller Executable Sections of Code
  • Compare SQL to PL/SQL on Performance
  • Understand How Bulk Binds Can Improve Performance
  • The FORALL Option


  • Before attending this course, students must have an understanding of Oracle8i or Oracle9i, or 10g Database Administration
  • Experience in Oracle tuning, backup and recovery
  • Networking
  • SQL & PL/SQL programming experience is also required


Latest comments from students

User: mendezjames

Instructor comments: Excellent instructor. Explained concepts very well.

Liked the class?  Then let everyone know!