Oracle9i PL/SQL: A Developer's Guide

Oracle9i PL/SQL: A Developer’s 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 Developer’s 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