Contents

Title and Copyright Information

Preface

What's New in Application Development?

1 Introduction to Oracle Programmatic Environments

Part I SQL for Application Developers

2 SQL Processing for Application Developers

3 Using SQL Data Types in Database Applications

4 Using Regular Expressions in Database Applications

5 Using Indexes in Database Applications

6 Maintaining Data Integrity in Database Applications

Part II PL/SQL for Application Developers

7 Coding PL/SQL Subprograms and Packages

8 Using PL/Scope

9 Using the PL/SQL Hierarchical Profiler

10 Developing PL/SQL Web Applications

11 Developing PL/SQL Server Pages

12 Using Continuous Query Notification

Part III Advanced Topics for Application Developers

13 Using Oracle Flashback Technology

14 Developing Applications Using Multiple Programming Languages

15 Developing Applications with Oracle XA

16 Developing Applications on the Publish-Subscribe Model

17 Using the Identity Code Package

A Multithreaded extproc Agent

Index