Structure of PL/SQL Block

[<Block Header>]

[DECLARE

<constants>

<variables>

<Cursors>

<user defined exceptions>

]

BEGIN

<PL/SQL Statements>

[Exceptions <exception handlings>]

END;

BLOCK HEADER specifies whether the PL/SQL block is procedure, a function or a package. If no header is specified, the block is said to be an anonymous PL/SQL block.

LOOP in PL/SQL

Syntax:

LOOP

statements

END LOOP;

Example:

DECLARE

cntr NUMBER :=0;

BEGIN

LOOP

cntr :=cntr +1;

IF cntr>100 THEN

Dbms_Output.put_line (cntr);

EXIT;

END IF;

END LOOP;