Oracle9i PL/SQL: A Developer's Guide

Bulusu Lakshman

  • 出版商: Apress
  • 出版日期: 2002-11-15
  • 售價: $2,060
  • 貴賓價: 9.5$1,957
  • 語言: 英文
  • 頁數: 665
  • 裝訂: Paperback
  • ISBN: 159059049X
  • ISBN-13: 9781590590492
  • 相關分類: OracleSQL
  • 海外代購書籍(需單獨結帳)



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