Product Description

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

Product Details

• Amazon Sales Rank: #16699 in Books
• Published on: 2008-03-21
• Number of items: 1
• Binding: Paperback
• 835 pages

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

The best book to understand Oracle's PL/SQL and how to use it effectively.
This is one of the best technical books I have read. It makes PL/SQL easy to learn for the beginners and it is so detailed that very experienced users will find it extremely useful. It covers the usage of PL/SQL with many different types of applications such as JAVA, XML, PHP, etc. I have recommended very few language books in my time, because, I have found them to be written with the writer's logic as to how the writer thinks the code would be better executed. However this is the first book that I have seen that is written logically based on how the language would be better used to efficiently interact with the database. In short, I give this book my highest recommendation. I would like to congratulate Michael on writing such a great book.

Mike Farmer
Michael McLaughlin has delivered the most comprehensive book on PL/SQL on the market. No matter where you are, novice or master, you will find this book helpful. The book is loaded with practical, working examples and detailed descriptions that will help you from getting lost. Even the most complex topics are covered thoroughly and comprehensively in a way that makes them feel simple. Even if you are not on 11g yet, you need to buy this book. It's not only a great reference, but an interesting and captivating read that will give you ideas and understanding which will help in any project.

Most of all, this book reveals the power of PL/SQL as a viable and fully-featured programming language. It covers complex subjects such as Object Oriented Programming and utilizing Large Objects (LOBS) with striking detail. It also contains a primer on using PHP and Java with PL/SQL! You'll also find a revealing discussion on using Functions, Procedures, and Packages that enhance understanding in a way that no other book does. Other books teach you the "how", this book covers the "what" and the "why" so that you not only can write the code, but you understand everything that it is doing.

I would highly recommend this book to anyone that uses PL/SQL no matter your current skill level. There's great content for everyone.