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