||Oracle Concepts by Burleson
Programmatic Interfaces to
This tutorial introduces you to the interface
layer between PL/SQL and the SQL data access. We will begin by
explaining the concept of cursor manipulation and show how cursors
allow row-at-a-time processing of data sets.
We will also explore call SQL from inside
PL/SQL, and conversely, calling PL/SQL inside Oracle SQL via built-in
functions. This tutorial also describes the process of storing
PL/SQL inside Oracle and shows how stored procedures, functions, and
packages are executed within Oracle.
Exception handling is an important part of
PL/SQL and the student must be proficient in using the EXCEPTIONS
clause to trap expected Oracle errors and force the PL/SQL to perform
appropriate error handling when an error occurs.
We wrap-up this tutorial with a discussion of
PL/SQL tables and see how they can improve the performance of database
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA