Oracle Database 10g Pl/Sql Programming

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/SQLfunctionality 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 andrecover 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