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
No comments:
Post a Comment
Thank you :
- kareem