Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series) by Michael McLaughlin (Mar 21, 2008)
Deliver dynamic, client / server PL / SQL applications with expert guidance from an Oracle programming professional. Featuring complete coverage of the latest features and tools, Oracle Database 11g PL / SQL exposes each topic, along with detailed explanations, cut and paste syntax examples, and case studies of real world. Access and modify database information, construct powerful PL / SQL, execute efficient queries, and deploy bulletproof security. You will also learn how to implement C, C + + and Java procedures, Web-enable your database, reducing development time and optimize performance.
Oracle.Database.11g Master SQL and PLSQL
Deliver dynamic, client / server PL / SQL applications with expert guidance from an Oracle programming professional. Featuring complete coverage of the latest features and tools, Oracle Database 11g PL / SQL exposes each topic, along with detailed explanations, cut and paste syntax examples, and case studies of real world. Access and modify database information, construct powerful PL / SQL, execute efficient queries, and deploy bulletproof security. You will also learn how to implement C, C + + and Java procedures, Web-enable your database, reducing development time and optimize performance.
Oracle.Database.11g Master SQL and PLSQL
- 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 varray, 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 and 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
