PL SQL WHILE LOOP:
The pl sql while loop repeatedly executes a block of statements until a particular condition is true. It first check the condition and executes a block of statements if condition is true.
PL SQL WHILE LOOP syntax:
WHILE condition LOOP //block of statements; END LOOP;
PL SQL WHILE LOOP example:
DECLARE num NUMBER := 1; BEGIN WHILE num <= 10 LOOP DBMS_OUTPUT.PUT_LINE(num); num := num+1; END LOOP; END;
1 2 3 4 5 6 7 8 9 10