WHILE Loops : While « PL SQL Statements « Oracle PL/SQL Tutorial

WHILE loops check the condition and execute a set of commands.

The loop is repeated until the loop is exited.

A WHILE loop is exactly equivalent to a regular loop with an EXIT WHEN as the first statement.

The condition is checked before the code in the loop is executed.

If the condition is false, the code in the loop will never be executed.

WHILE loop makes your code a little easier to read than with a normal loop.

WHILE condition LOOP
SQL> set serveroutput on
SQL> set echo on
  2           v_Calc NUMBER := 0;
  3     BEGIN
  4          WHILE v_Calc >= 10 LOOP
  5               v_Calc := v_Calc + 1;
  6               DBMS_OUTPUT.PUT_LINE('The value of v_Calc is ' || v_Calc);
  7          END LOOP;
  8     END;
  9     /

PL/SQL procedure successfully completed.


22.7.1.WHILE Loops
22.7.2.While loop
22.7.3.WHILE LOOP with counter
22.7.4.Calculate circle Area in WHILE loop
22.7.5.Example of a WHILE loop that never executes.
22.7.6.The EXIT and EXIT WHEN Statements
22.7.7.EXIT a WHILE LOOP with exit command
22.7.8.While Counter is initialized to NULL
22.7.9.Nested WHILE Loop
22.7.10.Use WHILE Loop to insert data to table
22.7.11.A complete example of using the cursor variable using a WHILE LOOP