Use for loop statement to set value to an integer variable
SQL>
SQL> set echo on
SQL>
SQL> DECLARE
2 v_MyChar VARCHAR2(20) := 'test';
3 v_NUMBER NUMBER;
4 V_Date DATE := SYSDATE;
5 v_counter INTEGER;
6 BEGIN
7 DBMS_OUTPUT.PUT_LINE('This is a Test');
8 DBMS_OUTPUT.PUT_LINE('Of Syntax Error Debugging');
9 For v_COUNTER IN 1..5 LOOP
10 DBMS_OUTPUT.PUT_LINE('You are in loop:' || v_counter);
11 END LOOP;
12 END;
13 /
This is a Test
Of Syntax Error Debugging
You are in loop:1
You are in loop:2
You are in loop:3
You are in loop:4
You are in loop:5
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>
SQL> --
Related examples in the same category