Oracle 9i PL/SQL Application Development is targeted to the intermediate level Oracle Developer designing or coding applications in SQL and PL/SQL. It assumes a working knowledge of Oracle SQL and PL/SQL. Advanced PL/SQL Programmers intending to learn PL/SQL 9i features will also benefit from this book. "Oracle 9i PL/SQL Application Development" will cover the techniques of using PL/SQL 9i (latest release of PL/SQL language) for server-side applications. It also covers PL/SQL 9i in exhaustive detail and provides the methodology for implementing quality-proof and robust applications. Bulusu Lakshman assists the reader in implementing techniques that are effective for real-world and code-centric Oracle applications which, in the long run, saves time and effort on the part of the PL/SQL developer and increases his or her level to that of an advanced developer.
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.
Inhaltsverzeichnis
PART I: INTRODUCTION. -
PART II: NON-OBJECT-ORIENTED FEATURES IN PL/SQL 9i: Cursors. - PL/SQL Records and Index-by Tables. - Error Message Handling. - Stored Subprograms (Procedures, Functions and Packages). - Dabatabse Triggers. - Native Dynamic SQL and Dynamic PL/SQL. - Autonomous Transactions. - Native Bulk Binds. -
PART III: OBJECT ORIENTED FEATURES IN PL/SQL 9i: The World of Objects. - Collections (VARRAYS and Nested Tables). - Large Objects. - PART IV: PL/SQL WITH JAVA AND THE WEB: Floating in Java. - PL/SQL and the Web. - PART V: PL/SQL PERFORMANCE AND STANDARDS: Performance Considerations. - PL/SQL Coding Standards. - PART VI: APPENDIX. Case Stuides and Schema Objects. - Index.
