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
Post a Comment