Oracle PL/SQL Performance Tuning Tips & Techniques

PARTIILinking SQL and PL/SQL

Introduction to Part II

It is impossible to discuss PL/SQL without also discussing SQL operations because the main purpose of PL/SQL is to provide the fastest and most efficient way of extending the relational database environment into the realm of procedural logic. Part II of this book focuses on the best ways to link SQL and PL/SQL.

The most important thing to remember is that SQL and PL/SQL are completely separate languages, each with its own strengths and weaknesses. SQL and PL/SQL have different memory structures, optimization mechanisms, and so forth. The critical difference between them is that PL/SQL is a procedural ...