Textbook

Books Price Comparison (Including Amazon) - Guaranteed Lowest Prices on Books


 

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

 
 
 
 
Oracle Database 11g PL/SQL Programming (Oracle Press)
Author: Michael McLaughlin
ISBN 13: 9780071494458
ISBN 10: 71494456
Edition: 1
Publisher: McGraw-Hill Education
Publication Date: 2008-04-11
Format: Paperback
Pages: 835
List Price: $65.00
 
 

Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming 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.

  • 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