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>