Oracle PL/SQL - FOR loop with reverse directions

Introduction

You can reverse directions and go from the upper bound to the lower one:

Demo

SQL>
SQL> begin--   w  w  w.  j a v a  2s. co  m
  2      for main_c in reverse 1..3
  3      loop
  4          DBMS_OUTPUT.put_line(main_c);
  5      end loop;
  6  end;
  7  /
3
2
1

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 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 variable upper or lower bounds
• Using FOR loop

• Previous
• Next