[ 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;

ITPub博客

PLSQL Language Referenc-PL/SQL控制语句-循环语句-FOR循环