Introduction to PL/SQL

PL/SQL stands for procedural language extension of Structured Query Language [SQL].
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.It enable programmers to codify procedures, functions, and anonymous blocks that combine SQL statements

PL/SQL is a combination of Structured Query Language along with the procedural features of programming languages which was developed by Oracle Corporation in the early 1990’s to enhance the capabilities of SQL.

Oracle introduced PL/SQL to extend some limitations of SQL to provide a more comprehensive solution for building mission-critical applications running on Oracle database.

This was small introduction to PL/SQL which was necesary before the actual tutorial begin.

Index - PL/SQL Tutorial

Introduction to PL/SQL
Chap 1 : Block structure and Advantages of PL/SQL
Chap 2 : PL/SQL Variables and Constants
Chap 3 : PL/SQL Records
Chap 4 : PL/SQL IF ELSE statement / Conditional statements
Chap 5 : PL/SQL FOR and WHILE LOOP / Iterative Statements
Chap 6 : Cursors in PL/SQL
Chap 7 : PL/SQL Procedures
Chap 8 : PL/SQL Functions
Chap 9 : Parameters-Procedure and Function in PL/SQL
Chap 10 : What are PL/SQL Triggers
Chap 11 : Exception Handling in PL/SQL