Read more
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.
List of contents
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.
