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.

pl-sql.jpg

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

DECLARE

    declaration statements;

BEGIN

    executable statements

EXCEPTIONS

    exception handling statements

END;

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: