Oracle Advanced PL/SQL Developer Professional Guide

Since the time Saurabh Gupta was introduced to Oracle database by chance and not by choice, he has been synchronizing his on job and off job interests with Oracle database programming. As an Oracle 11g Certified Advanced PL/SQL Professional, he soon moved from programming to database designing, development, and administration. During the phase when he specialized in database modelling, development and tuning, he was an active Oracle blogger and OTN forum member. To date, he has authored more than 70 online articles and papers. His works can be noted at RMOUG SQL> Update journal, PSOUG (http://www.psoug.org), DBANOTES (http://www.dbanotes.com), EXFORSYS (http://www.exforsys.com), and CLUB-ORACLE (http://www.club-oracle.com). He shares his technical encounters in Oracle technologies on his own blogging venture http://sbhoracle.wordpress.com/. He is an AIOUG (All India Oracle Users Group) member and loves to participate in technical meets and conferences. Besides digging into Oracle, sketching and snooker are other past times for him. One can reach him through his blog SbhOracle for any comments, suggestions or feedback regarding this book.

Preface Chapter 1: Overview of PL/SQL Programming Concepts Chapter 2: Designing PL/SQL Code Chapter 3: Using Collections Chapter 4: Using Advanced Interface Methods Chapter 5: Implementing VPD with Fine Grained Access Control Chapter 6: Working with Large Objects Chapter 7: Using SecureFile LOBs Chapter 8: Compiling and Tuning to Improve Performance Chapter 9: Caching to Improve Performance Chapter 10: Analyzing PL/SQL Code Chapter 11: Profiling and Tracing PL/SQL Code Chapter 12: Safeguarding PL/SQL Code against SQL Injection Attacks Appendix: Answers to Practice Questions Index