Use for loop statement to set value to an integer variable : Integer « Data Type « Oracle PL / SQL






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

1.Use ANSI Data Types when creating a table
2.Define integer variables
3.Int value column