SET SERVEROUTPUT ON;


DECLARE

    v_counter NUMBER := 1;

    v_Number NUMBER := 1;

BEGIN

    DBMS_OUTPUT.PUT_LINE('Before loop: Counter=' || TO_CHAR(v_counter));

    DBMS_OUTPUT.PUT_LINE('Before loop: Number=' || TO_CHAR(v_Number));

    DBMS_OUTPUT.PUT_LINE('-----------------------');

    

    WHILE v_counter <= 10 LOOP

        DBMS_OUTPUT.PUT_LINE(TO_CHAR(v_Number));

        v_counter := v_counter + 1;

        v_Number := v_Number + 2;

    END LOOP;

    

    DBMS_OUTPUT.PUT_LINE('-----------------------');

    DBMS_OUTPUT.PUT_LINE('After loop: v_counter=' || TO_CHAR(v_counter));

    DBMS_OUTPUT.PUT_LINE('Before loop: Number=' || TO_CHAR(v_Number));

END;

/

Comments