1. PL SQL Introduction

In Oracle Database Management System, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and programming language. - From Wikipedia

1. PL/SQL stands for Procedural Language / Structured Query Language.
2. Extensively use to code Server Side Programming.
3. Case Insensitive Programming Language.

Type of Blocks in PL/SQL:

1. Anonymous Block
2. Named Block

PL/SQL Writing Pattern:

Declaration Section
            .....        (Optional)
Execution Section
            .....        (Mandatory)
Exceptional Handling Section
            .....        (Optional)

Syntax:

DECLARE
            Declaration Section;
BEGIN
            Execution Section;
EXCEPTION
            Exception Handling Section;
END;