Oracle PL/SQL - FOR LOOP Statement Index with Same Name as Variable

Introduction

If the index of a FOR LOOP statement has the same name as a variable declared in an enclosing block, the local implicit declaration hides the other declaration.

Demo

SQL>
SQL> DECLARE--   ww  w .j  av a 2  s .co m
  2    i NUMBER := 5;
  3  BEGIN
  4    FOR i IN 1..3 LOOP
  5      DBMS_OUTPUT.PUT_LINE ('Inside loop, i is ' || TO_CHAR(i));
  6    END LOOP;
  7
  8    DBMS_OUTPUT.PUT_LINE ('Outside loop, i is ' || TO_CHAR(i));
  9  END;
 10  /
Inside loop, i is 1
Inside loop, i is 2
Inside loop, i is 3
Outside loop, i is 5

PL/SQL procedure successfully completed.

SQL>

Related Topic

• FOR LOOP Statement
• Reverse FOR LOOP Statements
• Simulating STEP Clause in FOR LOOP Statement
• FOR LOOP Statement References Variable with Same Name as Index
• Nested FOR LOOP Statements with Same Index Name
• FOR LOOP Statement Bounds
• Specifying FOR LOOP Statement Bounds at Run Time
• EXIT WHEN Statement in FOR LOOP Statement
• EXIT WHEN Statement in Inner FOR LOOP Statement
• CONTINUE WHEN Statement in Inner FOR LOOP Statement
• Nested For loop
• FOR loop with reverse directions
• FOR loop with variable upper or lower bounds
• Using FOR loop

• Previous
• Next