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 PL/SQL Control Statements

5 PL/SQL Collections and Records

6 PL/SQL Static SQL

7 PL/SQL Dynamic SQL

8 PL/SQL Subprograms

9 PL/SQL Triggers

10 PL/SQL Packages

11 PL/SQL Error Handling

12 PL/SQL Optimization and Tuning

13 PL/SQL Language Elements

14 SQL Statements for Stored PL/SQL Units

A PL/SQL Source Text Wrapping

B PL/SQL Name Resolution

C PL/SQL Program Limits

D PL/SQL Reserved Words and Keywords

E PL/SQL Predefined Data Types

Index