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

Michael McLaughlin

ISBN 10: 0071494456 / ISBN 13: 9780071494458

Published by McGraw-Hill Education 2008-05-16, 2008

About this Item

Seller Inventory # 6666-ING-9780071494458

Bibliographic Details

• Title: Oracle Database 11g PL/SQL Programming (Oracle Press)
• Publisher: McGraw-Hill Education 2008-05-16
• Publication Date: 2008
• Language: English
• ISBN 10: 0071494456
• ISBN 13: 9780071494458
• Binding: Paperback
• Condition: New

About this title

Synopsis

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.




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

About the Author

Michael McLaughlin is a professor of Computer Information Technology at BYU-Idaho, the author of Oracle Database 10g Express Edition PHP Web Programming, and coauthor of the previous edition of this book. He has been working with PL/SQL since release 1.