Introduction
Explain the course objectives
Identify the Oracle product line
Describe the basic concepts of a PL/SQL

Programming with PL/SQL
Language structure
Declaration
Data types
Name resolve
Control statements
Procedures
Exceptions
Cursors

Develop PL/SQL program units
Stored procedures
Packages
Procedure & package management
Triggers
Dependency

Objects
Class Diagram
Object types
Object type in tables
Encapsulation
Inheritance
Polymorphism
Altering types

Large Objects
Convert to LOB
LOB constructor
Processing LOB types

Collections
Collection types
Processing of collections
Collection in tables
Collection objects