1. CREATE OR REPLACE PROCEDURE sp_test_for_loop
    2. IS
    3. BEGIN
    4.     FOR i IN 1..10 LOOP 
    5.         dbms_output.put_line('i is ' || to_number(i) );
    6.     END LOOP;
    8. EXCEPTION 
    9.     WHEN OTHERS THEN
    10.         NULL;   
    11. /
    12. delimiter ;
    14. obclient>
    15. obclient> set serveroutput on;
    16. Query OK, 0 rows affected (0.01 sec)
    18. obclient> call sp_test_for_loop();
    19. Query OK, 0 rows affected (0.06 sec)
    21. i is 2
    22. i is 3
    23. i is 4
    24. i is 5
    25. i is 6
    26. i is 7
    27. i is 8
    28. i is 9
    29. i is 10
    30. obclient>