Oracle Database 11g PL/SQL Programming (Oracle Press)

Oracle Database 11g PL/SQL Programming (Oracle Press)

<strong>Design Feature-Rich PL/SQL Applications</strong><p>Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, <em>Oracle Database 11g PL/SQL Programming</em> lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.</p><ul><li><div>Create, debug, and manage Oracle-driven PL/SQL programs</div></li><li><div>Use PL/SQL structures, delimiters, operators, variables, and statements</div></li><li>Identify and eliminate errors using PLSQL_WARNINGS and exception handlers</li><li>Work with functions, procedures, packages, collections, and triggers</li><li>Define and deploy varray, nested table, and associative array data types</li><li><div>Handle external routines, object types, large objects, and secure files</div></li><li><div>Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE</div></li><li>Call external procedures through Oracle Net Services and PL/SQL wrappers</li><li>Integrate internal and server-side Java class libraries using Oracle JVM</li><li>Develop robust Web applications using PL/SQL Gateway and Web Toolkit</li></ul>