What Are Block Types In PL/SQL

PL/SQL stands for the procedural language-standard query language. Similar to SQL language PL/SQL is also a case-insensitive programming language.

PL/SQL Blocks

Mostly a program written in PL/SQL language is divided into blocks.  PL/SQL Blocks contain a set of instructions for Oracle to execute, display information to the screen, write data to file, all other programs, and manipulate data and many more.

Both types of PL/SQL blocks are further divided into 3 different sections which are:

1.    The Declaration Section

2.    The Execution Section and

3.    The Exception-handling Section

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

About Mariano

I'm Ethan Mariano a software engineer by profession and reader/writter by passion.I have good understanding and knowledge of AngularJS, Database, javascript, web development, digital marketing and exploring other technologies related to Software development.