INTRODUCTION TO PL/SQL

language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed to oracle engine all at once which increases processing speed and decreases the traffic.

Basics of PL/SQL

PL/SQL stands for Procedural Language extensions to the Structured Query Language (SQL). PL/SQL is a combination of SQL along with the procedural features of programming languages. Oracle uses a PL/SQL engine to processes the PL/SQL statements. PL/SQL includes procedural language elements like conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variable of those types and triggers.