Oracle 9i PL/SQL Control Structures Page - 2

Page 2 of 2

Author : Exforsys Inc. Published on: 26th Feb 2005 | Last Updated on: 6th Apr 2011

Oracle 9i PL/SQL Control Structures

WHILE-LOOP

This is similar to LOOP. A condition placed between WHILE and LOOP is evaluated before each iteration. If the condition evaluates to TRUE the statements are executed and the control resumes at the top of the LOOP. If the condition evaluates to FALSE or NULL then control comes out of the loop.

Ads

FOR – LOOP:

The FOR – LOOP is used to repeatedly execute a set of statements for certain number of times specified by a starting number and an ending number. The variable value starts at the starting value given and increments by 1(default and can not be changed) with each iteration. The iteration stops when the variable value reaches end value specified.

Syntax:

FOR IN

LOOP

Statements

END LOOP;

Sequential Control Statements

The GOTO statement is used for doing unconditional branching to a named label. Its frequent usage is not recommended. We should have at least one executable statement following the label. GOTO statements can some time result in complex, unstructured code making it difficult to understand.

Ads

Points To be remembered while working with GOTO:

A statement, at least NULL statement, must follow every GOTO statement
A GOTO statement can branch to enclosing block from the current block
A GOTO statement cannot branch from one IF statement clause to another.
A GOTO statement cannot branch from an enclosing block into a sub-block.
A GOTO statement cannot branch out of a subprogram.
A GOTO cannot branch from an exception handler to current block. But it can branch from the exception handler to an enclosing block

1 2

Read Next: Oracle 9i Cursors

This tutorial is part of a Oracle 9i Training tutorial series. Read it from the beginning and learn yourself.

Oracle 9i Training