PacktLib: Oracle Advanced PL/SQL Developer Professional Guide

Oracle Advanced PL/SQL Developer Professional Guide

Credits

Foreword

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Overview of PL/SQL Programming Concepts

PL/SQL—the procedural aspect

PL/SQL development environments

Procedures

Functions

PL/SQL packages

Cursors—an overview

Exception handling in PL/SQL

Managing database dependencies

Reviewing Oracle-supplied packages

Summary

Practice exercise

Designing PL/SQL Code

Understanding cursor structures

Cursor variables

Subtypes

Summary

Practice exercise

Using Collections

Collections—an overview

Associative arrays

Nested tables

Varray

Collections—a comparative study

PL/SQL collection methods

Manipulating collection elements

Collection initialization

Summary

Practice exercise

Using Advanced Interface Methods

Understanding external routines

Executing external C programs from PL/SQL

Executing Java programs from PL/SQL

Summary

Practice exercise

Implementing VPD with Fine Grained Access Control

Fine Grained Access Control

VPD implementation—outline and components

VPD implementation—demonstrations

VPD policy metadata

Policy utilities—refresh and drop

Summary

Practice exercise

Working with Large Objects

Introduction to the LOB data types

Understanding the LOB data types

Creating LOB data types

Managing LOB data types

Working with the CLOB, BLOB, and BFILE data types

Migrating from LONG to LOB

Using temporary LOBs

Summary

Practice exercise

Using SecureFile LOBs

Introduction to SecureFiles

Working with SecureFiles

Migration from BasicFiles to SecureFiles

Summary

Practice exercise

Compiling and Tuning to Improve Performance

Native and interpreted compilation techniques

Tuning PL/SQL code

Enabling intra unit inlining

PRAGMA INLINE

Summary

Practice exercise

Caching to Improve Performance

Introduction to result cache

Configuring the database for the server result cache

Implementing the result cache in SQL

Implementing result cache in PL/SQL

Summary

Practice exercise

Analyzing PL/SQL Code

Track coding information

Using SQL Developer to find coding information

Determining identifier types and usages

The DBMS_METADATA package

Summary

Practice exercise

Profiling and Tracing PL/SQL Code

Tracing the PL/SQL programs

Profiling the PL/SQL programs

Summary

Practice exercise

Safeguarding PL/SQL Code against SQL Injection Attacks

SQL injection—an introduction

Immunizing SQL injection attacks

Testing the code for SQL injection flaws

Summary

Practice exercise

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Answers to Practice Questions

Index