The Concise Expert Guide to PL/SQL

Become an expert in designing and writing PL/SQL, and get the best performance from your Oracle 11g database.
This book starts from the basics and continues on to cover PL/SQL’s advanced capabilities, describing the latest language features and functionality along the way – including all items on the curriculum for the Oracle 11g Advanced PL/SQL certification exam 1Z0-146.
Among the core PL/SQL development skills, you’ll learn how to use PL/SQL to interact with the database most effectively, how to take full advantage of collections and bulk SQL, and how best to create stored subprograms and packages.
New features described alongside these include the Result Cache, newly available optimization techniques such as native compilation; plus compound triggers, the Hierarchical Profiler and PL/Scope. Security is a constant consideration and the narrative describes how to implement a VPD and to avoid SQL injection attacks on your code.
All of the 21 chapters are packed with short and practical examples designed to get you up and running as quickly as possible. All the sample code is also available on the book’s companion website.
The author has worked daily with PL/SQL for many years, and has delivered numerous PL/SQL solutions across a diverse range of industries.