DBMS LAB MANUAL Loops in PL/SQL - Code

Latest

programs

Wednesday, October 12, 2011

DBMS LAB MANUAL Loops in PL/SQL


Loops in PL/SQL
There are three types of loops in PL/SQL: 
1.    Simple Loop
2.    While Loop
3.    For Loop
1. Simple Loop: A Simple Loop is used when a set of statements is to be executed at least once before the loop terminates. An EXIT condition must be specified in the loop, otherwise the loop will get into an infinite number of iterations. When the EXIT condition is satisfied the process exits from the loop.
Syntax: 
LOOP
            statements;
 EXIT;
            {or EXIT WHEN condition ;}
END LOOP;

2. While Loop: A WHILE LOOP is used when a set of statements has to be executed as long as a condition is true. The condition is evaluated at the beginning of each iteration. The iteration continues until the condition becomes false.
Syntax: 
WHILE <condition>
            LOOP statements;
END LOOP;

3. FOR Loop: A FOR LOOP is used to execute a set of statements for a predetermined number of times. Iteration occurs between the start and end integer values given. The counter is always incremented by 1. The loop exits when the counter reaches the value of the end integer.
Syntax: 
FOR counter IN val1..val2
 LOOP statements;
END LOOP

No comments:

Post a Comment