Example of a WHILE loop that never executes. : While « PL SQL Statements « Oracle PL/SQL Tutorial

DECLARE
      v_Calc NUMBER := 0;
BEGIN
     WHILE v_Calc >= 10 LOOP
          v_Calc := v_Calc + 1;
          DBMS_OUTPUT.PUT_LINE('The value of v_Calc is ' || v_Calc);
     END LOOP;
END;
/


Corrected WHILE loop that executes.


SQL> DECLARE
  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  /
The value of v_Calc is 1
The value of v_Calc is 2
The value of v_Calc is 3
The value of v_Calc is 4
The value of v_Calc is 5
The value of v_Calc is 6
The value of v_Calc is 7
The value of v_Calc is 8
The value of v_Calc is 9
The value of v_Calc is 10
The value of v_Calc is 11

PL/SQL procedure successfully completed.

SQL>

22.7.While
	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