PLSQL Language Referenc-PL/SQL控制語句-迴圈語句-FOR迴圈

[ label ] FOR index IN [ REVERSE ] lower_bound..upper_bound LOOP

    statements                  

END LOOP [ label ];

BEGIN

    DBMS_OUTPUT.PUT_LINE ('下限 < 上限');

    FOR i IN 1..3 LOOP

        DBMS_OUTPUT.PUT_LINE (i);

    END LOOP;

    DBMS_OUTPUT.PUT_LINE ('下限 = 上限');

    FOR i IN 2..2 LOOP

        DBMS_OUTPUT.PUT_LINE (i);

    END LOOP;

    DBMS_OUTPUT.PUT_LINE ('下限 > 上限');

    FOR i IN 3..1 LOOP

        DBMS_OUTPUT.PUT_LINE (i);

    END LOOP;

END;

-- FOR迴圈中模擬自定義遞增步長

DECLARE

    step  PLS_INTEGER := 5;

BEGIN

    FOR i IN 1..3 LOOP

        DBMS_OUTPUT.PUT_LINE (i * step);

    END LOOP;

END;