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.

Duration: 2 Days

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 Database Administration, experience in Oracle tuning, backup and recovery, & networking, & SQL & PL/SQL programming experience is also required.

This course is designed for Oracle8i or Oracle9i Database Administrators who want a comprehensive overview of the New Features of Oracle10g.