Features
- Cover Type: Paperback with 835 pages
- Published by: McGraw-Hill Osborne Media
- Edition: 1st Edition March 21, 2008
- Written in: English
- ISBN 10 Number: 0071494456
- ISBN 13 Number: 978-0071494458
-
Book Dimensions:
9.1 x 7.3 x 1.9 inches
- Weighs: 3 pounds
Product Description
Design Feature-Rich PL/SQL ApplicationsDeliver 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.
Reader ReviewsYou can't go wrong with this book! It is truly comprehensive. I highly recommend it.