PLSQL Introduction

What is PL/SQL ?

Procedural Language/SQL or simply PL/SQL is an extension (procedural) to SQL.

PL/SQL provides features like data encapsulation, information hiding,exception handling and object oriented programming concepts into Oracle.

With tight integration of SQL language PL/SQL has became a good transaction processing language.

Moreover, the PL/SQL blocks or program units can be stored into the server making it more reusable.

PL/SQL Environment

As show in the above figure, a single PL/SQL block will be sent to oracle server instead of multiple

SQL statements where SQL statements will be separated and executed by SQL statement executor and improving performance.