SIMPLE PL/SQL PROGRAMS Rules | sql execution | sql conditional control |sql data command |sql iterative control

PROGRAMS:
PL/SQL block structure
DECLARE:
Declaration of memory various used later.
BEGIN:
SQL executable statements for manipulating table data.
EXECUTION:
SQL and or PL/SQL code to handle errors that may crop us during the execution of the above
code blocks.
CONDITIONAL CONTROL:
A sequence of statements can be executed based on some condition using IP.
Syntax: who am i


Date command:
The date command is used to print the system date and time.
Syntax: if <condn> then <action>
Else
<Action>
endif

ITERATIVE CONTROL:
A sequence of statements can be executed any number of times using the loop
constructs..
Syntax: loop
Stmts;
End loop;