|
Oracle 9i 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.
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
|
