Introduction PL/SQL

Basic PL/SQL

Advance PL/SQL

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.

PL/SQL Tutorial


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).


PL/SQL (Procedural Language/Structured Query Language) program executes on Oracle database.
PL/SQL includes procedural language elements (like declaration, conditions, looping), also, you can able to handle a runtime exception.


Introduction PL/SQL

PL/SQL Condition Looping Sequential Case

PL/SQL Transaction Cursor Exception


Advance PL/SQL