What is pl sql block?

devquora
devquora

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    PL/SQL Interview Questions

    What is PL/SQL?

    PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..

    PL/SQL Interview Questions

    Differentiate between PL/SQL and SQL?

    PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..

    PL/SQL Interview Questions

    State few characteristics of PL/SQL?

    Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..