Book Image

Oracle Advanced PL/SQL Developer Professional Guide

By : Saurabh K. Gupta
Book Image

Oracle Advanced PL/SQL Developer Professional Guide

By: Saurabh K. Gupta

Overview of this book

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database. Server-side PL/SQL is stored and compiled in the Oracle Database and runs within the Oracle executable. With this guide Oracle developers can work towards accomplishing Oracle 11g Advanced PL/SQL Professional certification, which is the second milestone for developers working at the Associate level. The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. Besides the clear and precise explanation on advanced topics, it also contains example code and demonstrations, which gives a sense of application and usage to readers.The book gives a deep insight that will help transform readers from mid-level programmers to professional database developers. It aims to cover the advanced features of PL/SQL for designing and optimizing PL/SQL code.This book starts with an overview of PL/SQL as the programming database language and outlines the benefits and characteristics of the language. The book then covers the advanced features that include PL/SQL code writing using collections, tuning recommendations using result caching, implementing VPD to enforce row level security, and much more. Apart from programming, the book also dives deep into the usage of the development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.
Table of Contents (22 chapters)
Oracle Advanced PL/SQL Developer Professional Guide
Credits
Foreword
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

About the Reviewers

Kamran Agayev A. is an Oracle ACE and Oracle Certified Professional DBA working at Azercell Telecom. He's an author of the book, Oracle Backup & Recovery: Expert secrets for using RMAN and Data Pump, and also shares his experience with a lot of step-by-step articles and video tutorials in his blog at http://kamranagayev.com. He also presents at Oracle OpenWorld, TROUG, and local events.

Mohan Dutt is an Oracle expert, having presented more than 55 sessions at Oracle conferences worldwide. An Oracle evangelist at large, he was awarded Member of the Year by Oracle Applications User Group (OAUG) in 2007. He authors the world's first blog dedicated entirely to Oracle certification. He has founded and chaired 3 Oracle Special Interest Groups (SIG). He was recognized as an Oracle ACE in 2011.

Marcel Hoefs learned his trade participating in numerous Oracle development projects, as an Oracle developer, since 1997. Being a specialist in SQL and PL/SQL database development, Oracle Forms, Reports, and Designer, Marcel currently works as a Technical Architect, Lead Developer, and Performance Specialist. With the advent of web technologies such as Web Services, ADF, and APEX, he currently specializes in innovative solutions opening up traditional Oracle database systems to the Web. As a senior Oracle Consultant with CIBER, he is also an Oracle competence leader, organizing and participating in knowledge sharing sessions with participants from within and outside CIBER.

Ronald Rood is an innovating Oracle DBA with over 20 years of IT experience. He has built and managed cluster databases on almost each and every platform that Oracle has ever supported, from the famous OPS databases in version 7, until the latest RAC releases, currently being 11g. Ronald is constantly looking for ways to get the most value out of the database to make the investment for his customers even more valuable. He knows how to handle the power of the rich Unix environment very well and this is what makes him a first class trouble-shooter and a true Oracle ACE. Next to the spoken languages such as Dutch, English, German, and French, he also writes fluently in many scripting languages.

Currently, Ronald is a principal consultant working for CIBER in The Netherlands where he cooperates in many complex projects for large companies where downtime is not an option. CIBER or CBR is a global full service IT provider and Oracle Platinum Partner.

Ronald often replies in the Oracle forums, writes his own blog (http://ronr.blogspot.com) called "From errors we learn" and writes for various Oracle related magazines. He also wrote a book, Mastering Oracle Scheduler in Oracle 11g Databases, where he fills the gap between the Oracle documentation and customers' questions. You can find him on Twitter at http://twitter.com/ik_zelf.

Ronald has lots of certifications:

  • Oracle Certified Master

  • Oracle Certified Professional

  • Oracle Database 11g Tuning Specialist

  • Oracle Database 11g Data Warehouse Certified Implementation Specialist

Ronald fills his time with Oracle, his family, sky-diving, radio controlled model airplane flying, running a scouting group, and having a lot of fun.

He quotes, "A problem is merely a challenge that might take a little time to be solved".