Oracle Database 11g PL/SQL Programming : Develop Robust, Database-Driven PL/SQL Applications / McLaughlin, Michael

It includes Appendixes and Index Pages



About The Book

Oracle Database 11g PL/SQL Programming is a comprehensive guide that helps you to deliver high-quality client/server PL/SQL applications. The guide was written by an Oracle programming professional. The book is up-to-date in its information with all the latest features and tool. Each and every topic is described in a detailed manner, with cut-and-paste syntax examples and real-world case studies. Advanced topics such as Dynamic SQL and intersession communication are included. This is a great guide to learn programming and structured query languages.

The book teaches various aspects of writing PL/SQL applications. It will teach you to write powerful programs, interact with Oracle databases, perform complex calculations and handle error conditions. The book helps in accessing and modifying database information, constructing powerful PL/SQL statements, executing effective queries and deploying bulletproof security. Apart from Oracle database, the book also teaches you to implement C, C++ and Java procedures.

The uses of the book are listed as many. You can learn to create, debug and manage Oracle-driven PL/SQL programs; use PL/SQL structures, delimiters, operators, variables and statements; identify and eliminate errors using PLSQL_WARNINGS and exception handlers; work with functions, procedures, packages, collections and triggers; define and deploy array, nested table and associative array data types; handle external routines, object types, large objects and secure files; communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE; call external procedures through Oracle Net Services ans PL/SQL wrappers; integrate internal and server-side Java class libraries using Oracle JVM; develop robust web applications using PL/SQL Gateway and Web Toolkit. Oracle Database 11g PL/SQL Programming was published on 28 April 2008 in paperback.