SQL>
SQL> -- Example of a WHILE loop that never executes.
SQL> set serveroutput on;
SQL>
SQL> DECLARE
2 c NUMBER := 0;
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE('The value of variable_Calc is ' || c);
5 WHILE c >= 10 LOOP
6 c := c + 1;
7 DBMS_OUTPUT.PUT_LINE('The value of variable_Calc is ' || c);
8 END LOOP;
9 END;
10 /
The value of variable_Calc is 0
PL/SQL procedure successfully completed.
SQL>