Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Statements

 

WHILE LOOP with counter

SQL> SQL> set serveroutput on SQL> set echo on SQL> 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     / PL/SQL procedure successfully completed. SQL>