PL/ SQL

PL/SQL stands for Procedural Language extension of SQL.

Oracle uses a PL/SQL engine to processes the PL/SQL statements. A PL/SQL code can be stored in the client system (client-side) or in the database (server-side).

PL/SQL Block consists of three sections:

• The Declaration section (optional).
• The Execution section (mandatory).
• The Exception (or Error) Handling section (optional)

DECLARE 

     Variable declaration 

BEGIN

     Program Execution 

EXCEPTION

     Exception handling 

END;

Advantages of PL/SQL 

1. Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or a logical module. PL/SQL Blocks can be stored in the database and reused. 
2. Procedural Language Capability: PL SQL consists of procedural language constructs such as conditional statements (if else statements) and loops like (FOR loops). 
3. Better Performance: PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.
4. Error Handling: PL/SQL handles errors or exceptions effectively during the execution of a PL/SQL program. Once an exception is caught, specific actions can be taken depending upon the type of the exception or it can be displayed to the user with a message.

Later, I'll add a presentation prepared by me...