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. Plus, you’ll get insider programming tips and techniques and real-world examples from the Oracle community.

• Develop, tune, and debug PL/SQL programs that access Oracle databases from a wide variety of environments
• Use PL/SQL block structures, variables, datatypes, expressions, operators, and statements
• Regulate and recover from errors using exceptions and exception handlers
• Deploy subprograms, procedures, functions, packages, and triggers
• Accomplish intersession communication with DBMS_PIPE and DBMS_ALERT
• Write object-oriented PL/SQL applications
• Manage large sets of data using PL/SQL records and objects
• Work with Oracle Net Services, external procedures, Java libraries, and C shared libraries
• Perform object-oriented programming using transient objects, inheritance, type evolution, and attribute chaining
• Automate database tasks with DBMS_JOB and DBMS_SCHEDULER and add e-mail functionality with UTL_SMTP and UTL_MAIL