PL SQL Statements Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. PL SQL Statements
  4. The upper or lower bounds of the FOR loop can be defined as variables or functions
SQL>
SQL> declare
  2      V_lower NUMBER:=2/3;
  3  begin
  4      for main_c in reverse v_lower..10/3
  5      loop
  6          DBMS_OUTPUT.put_line(main_c);
  7      end loop;
  8  end;
  9  /
3
2
1
PL/SQL procedure successfully completed.
SQL>