Product Description

The bestselling PL/SQL desktop reference--fully rewritten and expanded for Oracle Database 11g

Completely up-to-date for the new database release, this Oracle Press guide explains how to write robust, database-driven PL/SQL applications. Full details on the PL/SQL language, scripting semantics, and syntax are included. You will learn how to write powerful programs, interact with Oracle databases, perform complex calculations, and handle error conditions.

Oracle Database 11g PL/SQL Programming features a real-world example that runs throughout the book to illustrate the programming techniques presented. The book explains how various programming concepts work as well as how components fit together to solve programming problems. Advanced topics such as Dynamic SQL and intersession communication are also included.

Product Details

• Amazon Sales Rank: #74678 in Books
• Published on: 2008-05-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 835 pages

From the Back Cover
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.

Customer Reviews

Useful stuff - but needs an errata
I'm using this as a revision aid for exam 1Z0-147 which I'm taking in a week's time. I'm still reading it, and have found a lot of the content useful so far, but whilst struggling through chapter 7 (collections) I felt compelled to take a second to complain about how badly written and just plain wrong some of it is. There's a lot of repetition, and in places it looks like text or code examples are copied-and-pasted and not changed to reflect their new subject.
e.g
p.225
"Nested Tables"
"Like varrays, nested tables are single-dimensional structures of Oracle 11g SQL or PL/SQL datatypes. You can use them table [sic], record, and object definitions and access them in SQL and PL/SQL. You can also use nested tables in table, record, and object definitions. They are accessible in both SQL and PL/SQL."

I had a look on the Osborne web site but couldn't find any sort of errata anywhere.