PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s technical extension language for SQL plus the Oracle relational database. PL/SQL’s general syntax resembles that of Ada.
PL/SQL is one of three key programming languages entrenched in the Oracle Database, along with SQL itself and Java.
PL/SQL chains variables, conditions, loops and exceptions. Arrays are also supported, however in a somewhat strange way, involving the use of PL/SQL collections.
This is an example of simple Syntax of PL/SQL
The next picture shows how PL/SQL Runs
PL/SQL Program Blocks :
Header section : No header section for anonymous block
Declaration section : Optional
Execution section : Required
Exception section : Optional
Comment Statements : Using one of two ways — or Enclosed within /* and */
Written by :Mohammed Alaslani
References : Lecture slides and Wikipedia .
