Oracle Database 10G Pl/SQL Programming

Write Robust PL/SQL Applications 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. bull; bull;Develop, tune, and debug PL/SQL programs that access Oracle databases from a wide variety of environments bull;Use PL/SQL block structures, variables, datatypes, expressions, operators, and statements bull;Regulate and recover from errors using exceptions and exception handlers bull;Deploy subprograms, procedures, functions, packages, and triggers bull;Accomplish intersession communication with DBMS_PIPE and DBMS_ALERT bull;Write object-oriented PL/SQL applications bull;Manage large sets of data using PL/SQL records and objects bull;Work with Oracle Net Services, external procedures, Java libraries, and C shared libraries bull;Perform object-oriented programming using transient objects, inheritance, type evolution, and attribute chaining bull;Automate database tasks with DBMS_JOB and DBMS_SCHEDULER and add e-mail functionality with UTL_SMTP and UTL_MAILUrman, Scott is the author of 'Oracle Database 10G Pl/SQL Programming', published 2004 under ISBN 9780072230666 and ISBN 0072230665.