PL/SQL: Conditional, Logical, Loops

PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other.


Typically, each block performs a logical action in the program. A block has the following structure:


    declaration statements;


    executable statements


    exception handling statements


Execution section starts with BEGIN and ends with END keyword.This is a mandatory section and here the program logic is written to perform any task like loops and conditional statements. It supports all DML commands, DDL commands and SQL*PLUS built-in functions as well.

One thought on “PL/SQL: Conditional, Logical, Loops

Leave a Reply

error: Content is protected !!
%d bloggers like this: