Mega Code Archive
WHILE Loop
<![CDATA[
SQL>
SQL> DECLARE
2 v_count PLS_INTEGER := 1;
3 BEGIN
4 WHILE v_count <= 20
5 LOOP
6 DBMS_OUTPUT.PUT_LINE('While loop iteration: '||v_count);
7 v_count := v_count + 1;
8 END LOOP;
9 END;
10 /
While loop iteration: 1
While loop iteration: 2
While loop iteration: 3
While loop iteration: 4
While loop iteration: 5
While loop iteration: 6
While loop iteration: 7
While loop iteration: 8
While loop iteration: 9
While loop iteration: 10
While loop iteration: 11
While loop iteration: 12
While loop iteration: 13
While loop iteration: 14
While loop iteration: 15
While loop iteration: 16
While loop iteration: 17
While loop iteration: 18
While loop iteration: 19
While loop iteration: 20
PL/SQL procedure successfully completed.
SQL>
]]>