Oracle PL/SQL - Simulating STEP Clause in FOR LOOP Statement

Introduction

To simulate the STEP clause in PL/SQL, multiply each reference to the loop index by the desired increment.

Demo

SQL>
SQL>-- from w  ww  . j  a v a2  s .  co  m
SQL> DECLARE
  2    step  PLS_INTEGER := 5;
  3  BEGIN
  4    FOR i IN 1..3 LOOP
  5      DBMS_OUTPUT.PUT_LINE (i*step);
  6    END LOOP;
  7  END;
  8  /
5
10
15

PL/SQL procedure successfully completed.

SQL>

Related Topic

• FOR LOOP Statement
• Reverse FOR LOOP Statements
• FOR LOOP Statement Index with Same Name as Variable
• 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