Write Robust PL/SQL ApplicationsCreate 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 environmentsUse PL/SQL block structures, variables, datatypes, expressions, operators, and statementsRegulate and recover from errors using exceptions and exception handlersDeploy subprograms, procedures, functions, packages, and triggersAccomplish intersession communication with DBMS_PIPE and DBMS_ALERTWrite object-oriented PL/SQL applicationsManage large sets of data using PL/SQL records and objectsWork with Oracle Net Services, external procedures, Java libraries, and C shared librariesPerform object-oriented programming using transient objects, inheritance, type evolution, and attribute chainingAutomate database tasks with DBMS_JOB and DBMS_SCHEDULER and add e-mail functionality with UTL_SMTP and UTL_MAIL