PL/SQL Tutorial

Getting started PL/SQL tutorial for beginners as well as cover advanced topics such as PL/SQL data types, conditions and looping, type of cursor, how to handling PL/SQL exceptions, how to define PL/SQL functions, procedures, packages, and PL/SQL Trigger.

What is PL/SQL?

PL/SQL is a Procedural Language extension of Structured Query Language (SQL).
PL/SQL (Procedural Language/Structured Query Language) program executes on Oracle database.
PL/SQL is specially designed for Database oriented activities. Oracle PL/SQL allows you to perform data manipulation operation those are safe and flexible.

PL/SQL come after releasing Oracle database (version 7). The basic structure block of PL/SQL built using DECLARE, BEGIN, EXCEPTION(optional), END keywords. This keyword block are defined as a declaration block, executable block, exception handling block and last end block (for end of the structure).