Introduction of PL/SQL Block Structure

In this article I am going to explain about PL/SQL Block Structure.
  • 1940
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:
 

  1. Declarative (optional)
  2. Executable   (recurred)
  3. Exception handling (optional)

Note: Section keyword, Declare, Being and exception are not followed by semi colons.

Block Type

  1. Anonymous Block
  2. Procedure Block
  3. 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.

© 2019 DotNetHeaven. All rights reserved.