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;