SQL> SQL> set serveroutput on SQL> set echo on SQL> SQL> DECLARE 2 v_Start Integer := 1; 3 BEGIN 4 FOR v_loopcounter IN REVERSE v_Start..5 LOOP 5 DBMS_OUTPUT.PUT_LINE('Loop counter is ' || v_loopcounter); 6 END LOOP; 7 END; 8 / Loop counter is 5 Loop counter is 4 Loop counter is 3 Loop counter is 2 Loop counter is 1 PL/SQL procedure successfully completed. SQL>
22.4.For LOOP | ||||
22.4.1. | FOR Loops | |||
22.4.2. | FOR LOOP with loop counter | |||
22.4.3. | Nested FOR LOOP with Labels | |||
22.4.4. | Nested FOR loop counter | |||
22.4.5. | Nested three level LOOP | |||
22.4.6. | Reversed FOR LOOP | |||
22.4.7. | The upper or lower bounds of the FOR loop can be defined as variables or functions. | |||
22.4.8. | Nested IF statement in For loop | |||
22.4.9. | Use FOR LOOP to loop through dates | |||
22.4.10. | EXIT a FOR LOOP with exit command | |||
22.4.11. | FOR Loop Scoping Rules | |||
22.4.12. | FOR Loop Ranges | |||
22.4.13. | LOOP with Labels | |||
22.4.14. | A complete example if uisng the cursor variable using a cursor FOR LOOP | |||
22.4.15. | FOR year_number IN 1800..1995: define variable for a range type | |||
22.4.16. | Drop any objects to make script re-runnable: for in | |||
22.4.17. | For loop variable in a range of numbers | |||
22.4.18. | Reversed loop | |||
22.4.19. | variable-delimitted loop | |||
22.4.20. | EXPLAIN PLAN FOR select statement |