Posted On: Feb 22, 2018
Just like every procedural language, a block is the smallest valuable group of code. A block offers both scoping and execution boundaries for exception handling and declaring variables. PL/SQL offers you the opportunity to create blocks that have no name and blocks that have a name. These blocks might be triggers, packages, objects, procedures or function types. A PL/SQL block is made up of 4 sections. The 4 sections are declaration, exception, header and execution sections but just one is required. The header section is an optional section just like exception and declaration. Only the execution section is required or mandatory.
Never Miss an Articles from us.
PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..
PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..
Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..