Section 1Fundamentals
Introduction to PL/SQL
Benefits of PL/SQL
Creating PL/SQL Blocks
Review of SQL SELECT Statements
Review of SQL Single-Row Functions
Section 2Variables and Datatypes
Using Variables in PL/SQL
Recognizing PL/SQL Lexical Units
Recognizing Data Types
Using Scalar Data Types
Review of SQL Joins
Review of SQL Group Functions and Subqueries
Writing PL/SQL Executable Statements
Nested Blocks and Variable Scope
Good Programming Practices
Section 3 SQL in PL/SQL
Review of SQL DML
Retrieving Data in PL/SQL
Manipulating Data in PL/SQL
Using Transaction Control Statements
Section 4 Program Structure
Conditional Control: IF Statements
Conditional Control: Case Statements
Iterative Control: Basic Loops
Iterative Control: While and For Loops
Iterative Control: Nested Loops
Section 5 Cursors
Introduction to Explicit Cursors
Using Explicit Cursor Attributes
Cursor FOR Loops
Cursors with Parameters
Using Cursors For Update
Using Multiple Cursors
Section 6 Exceptions Handling
Handling Exceptions
Trapping Oracle Server Exceptions
Trapping User-Defined Exceptions
Recognizing the Scope of Variables
Section 7 Procedures
Creating Procedures
Using Parameters in Procedures
Passing Parameters
Section 8 Functions
Creating Functions
Using Functions in SQL Statements
Review of the Data Dictionary
Managing Procedures and Functions
Review of Object Privileges
Using Invoker's Rights
Section 9 Packages
Creating Packages
Managing Package Concepts
Advanced Package Concepts
Persistent State of Package Variables
Using Oracle-Supplied Packages
Dynamic SQL
Section 10 Triggers
Introduction to Triggers
Creating DML Triggers: Part I
Creating DML Triggers: Part II
Creating DDL and Database Event Triggers
Managing Triggers
Section 11 Advanced Data Types
Using Large Object Data Types
Managing Bfiles
User-Defined Records
Index By Tables of Records
Section 12 Dependencies
Understanding Dependencies
