Oracle 9i PL/SQL: A Developer's Guide

Description

Oracle9i PL/SQL: A Developers Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy.

Oracle9i PL/SQL: A Developers Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.

CONTENTS:

Part One Introduction

Chapter 1: Introduction to PL/SQL

Part Two Non-Object-Oriented Features in PL/SQL 9i

Chapter 2: Cursors

Chapter 3: PL/SQL Records and Index-by Tables

Chapter 4: Error Message Handling

Chapter 5: Stored Subprograms (Procedures, Functions, and Packages)

Chapter 6: Database Triggers

Chapter 7: Native Dynamic SQL and Dynamic PL/SQL

Chapter 8: Autonomous Transactions

Chapter 9: Native Bulk Binds

Part Three Object-Oriented Features in PL/SQL 9i

Chapter 10: The World of Objects

Chapter 11: Collections (VARRAYS and Nested Tables)

Chapter 12: Large Objects

Part Four PL/SQL with Java and the Web

Chapter 13: Floating in Java

Chapter 14: PL/SQL and the Web

Part Five PL/SQL Performance and Standards

Chapter 15: Performance Considerations

Chapter 16: PL/SQL Coding Standards

Part Six Appendix

Appendix A Case Studies and Schema Objects