PL/SQL (Procedural Language/Structured Query Language)

PL/SQL is a language that enables developers to create procedures, functions that combines sql with procedural statements.

PL/SQL block has three parts in it.

1. Declaration    All objects of the block are declared.

2. Execution       The objects are defined to manipulate data.

3. Exception       Error handling logic.

==>Declaration part is optional when we do not declare any objects

==>Exception part is also optional if we are not handling any exceptions.

==>But the Execution part is must in a PL/SQL Program and it starts with BEGIN and ends with END.

Execution:

========

To Execute the PL/SQL Program follow the syntax as

@<file_name>

or

start<file_name>

==>To Display the Result, give the command as follows

set serveroutput on