PL/SQL Block Structure
In this article I am going to explain about PL/SQL Block Structure. PL/SQL is a Block Structure Language, meaning that programs can be divided into logical blocks. PL/SQL is developed by oracle. In present time, PL/SQL is integrated component of oracle software. SQL provide limited support for advance programming and PL/SQL fill this gap. A PL/SQL block consists of up three section:
- Declarative (optional)
- Executable (recurred)
- Exception handling (optional)
Note: Section keyword, Declare, Being and exception are not followed by semi colons.
Block Type
- Anonymous Block
- Procedure Block
- Function Block
Anonymous Block:- Un_named PL/SQL Blocks that are embedded within on application or issued reiteratively.
Procedure Block:- Named PL/SQL Blocks Structure is an Oracle Forms developers application or shared library, can accept parameters and can be invoked repeatedly by name .
Function Block:- Named PL/SQL Blocks Stored is an Oracle server, can accept parameter and can be invoked repeatedly by name.