Oracle Database 10g PL/SQL Programming
Scott Urman, Lisa McClain · CERN Document Server (European Organization for Nuclear Research) · 1995
Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions. Table of contents PART I: Introduction Chapter 1: Introduction to PL/SQL Chapter 2: Using SQL*Plus and JDeveloper Chapter 3: PL/SQL Basics Chapter 4: Using SQL with PL/SQL Chapter 5: Records Chapter 6: Collections Chapter 7: Error Handling Chapter 8: Creating Procedures, Functions, and Packages Chapter 9: Using Procedures, Functions, and Packages Chapter 10: Database Triggers PART II: Advanced PL/SQL Features Chapter 11: Intersession Communication Chapter 12: External Routines Chapter 13: Dynamic SQL Chapter 14: Introduction to Objects Chapter 15: Objects in the Database Chapter 16: Large Objects Chapter 17: Scheduling Tasks PART III: Appendixes Appendix A: PL/SQL Reserved Words Appendix B: Guide to Supplied Packages