Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

What's New in PL/SQL?

1 Overview of PL/SQL

2 PL/SQL Language Fundamentals

3 PL/SQL Data Types

4 Using PL/SQL Control Structures

5 Using PL/SQL Collections and Records

6 Using Static SQL

7 Using Dynamic SQL

8 Using PL/SQL Subprograms

9 Using Triggers

10 Using PL/SQL Packages

11 Handling PL/SQL Errors

12 Tuning PL/SQL Applications for Performance

13 PL/SQL Language Elements

14 SQL Statements for Stored PL/SQL Units

A Wrapping PL/SQL Source Code

B How PL/SQL Resolves Identifier Names

C PL/SQL Program Limits

D PL/SQL Reserved Words and Keywords

Index