PL/SQL While Loop
PL/SQL While Loop
The Loop statement WHILE-LOOP run so long as the condition is true.
Syntax:
WHILE condition LOOP sql_statements LOOP END;
Example:
DECLARE
x NUMBER:=0;
BEGIN
WHILE x < 5
LOOP
x:= x + 1;
DBMS_OUTPUT.PUT_LINE (' x= ' || x);
END LOOP;
END;