PL/SQL Tutorial Introduction

PL/SQL (Procedural Language / Structured Query Language) is the procedural extension of SQL language. PL/SQL is a programming language that provides accessing data from a relational database-oriented objects and enables grouping of a multitude of commands into a single block of data handling.

PL/SQL is a language with block structure. It enable programmers to codify procedures, functions, and anonymous blocks that combine SQL statements with procedural instructions. Procedures, functions and cursors that form a logical drive can be grouped and stored together in packages. These packages may be provide parameters, which allows the procedures and functions to receive and return values.

PL/SQL Advantages

Integration with Oracle Server
Supports the basic SQL commands
Defining and managing blocks of instructions
Management of variables, constants and cursors
Allow implementation and use of triggers
Detection and management execution errors, exceptions

PL/SQL Blocks

PL/SQL is a language focused on blocks, with procedural and processing characteristics of error handling. These blocks are composed of procedures, functions, and anonymous blocks which are grouped together in logical point of view.

A PL/SQL block is composed of three parts:

Declaration - all block objects must be declared
Execution the objects are defined for the data processing
Exceptions here are located the error handling routines

DECLARE
   Declare Variables
BEGIN
   Execution Programs
EXCEPTION
   Errors handling
END;


PLSQL Tutorial Logo


PL SQL Tutorial modules: Blocks, Variables, Control structures, Collections and Records, Cursors, Create Procedures, Create Functions, Create Packages, Error Exception Handling, Create Triggers, Oracle Functions, Interview Questions and Answers, PL SQL Tutorial Examples

Others tutorials: TSQL, SQL Tutorial, SQL Plus, PL/SQL, Oracle Tutorial.