Oracle 9i PL/SQL: A Developer's Guide
- 7h 23m
- Bulusu Lakshman
- Apress
- 2003
- Focuses on Oracle PL/SQL 9i (Versions 9.2.x and 9.0.x) from an application developer’s perspective
- Includes tried-and-true methods for building fast and unbreakable Oracle9i PL/SQL applications
- Features highlighted key points in each chapter that are useful in focusing on real-world issues
Oracle9i PL/SQL: A Developer’s Guide is intended both for 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 9i features. In addition to providing developers with detailed coverage of the PS/SQL 9i language itself, author Bulusu Lakshman covers the techniques for 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 version will both find Lakshman’s expert treatment of the topic beneficial.
About the Author
Bulusu Lakshman is an experienced Oracle developer with more than 10 years of software design and development experience using Oracle and its related tools, including PL/SQL and Java. He’s the author of Oracle Developer Forms Techniques and Oracle and Java Development, both of which have been well received. He also holds an Oracle Master credential from Oracle Corporation, is an Oracle Certified Professional (OCP) application developer, and is a double honors graduate in computer science and engineering and mathematics. He has presented at numerous international and national conferences on Oracle and its tools, and he has published articles in various technical magazines and journals. Lakshman is currently employed by Compunnel Software Group Inc., a leading technical consulting firm based in New Jersey.
In this Book
-
Introduction to PL/SQL
-
Cursors
-
PL/SQL Records and Index-by Tables
-
Error Message Handling
-
Stored Subprograms (Procedures, Functions, and Packages)
-
Database Triggers
-
Native Dynamic SQL and Dynamic PL/SQL
-
Autonomous Transactions
-
Native Bulk Binds
-
The World of Objects
-
Collections (VARRAYS and Nested Tables)
-
Large Objects
-
Floating in Java
-
PL/SQL and the Web
-
Performance Considerations
-
PL/SQL Coding Standards
