DECLARE

x NUMBER := 0;

BEGIN

LOOP

DBMS_OUTPUT.PUT_LINE('循环之中: x = ' || TO_CHAR(x));

x := x + 1; --避免无限循环

EXIT WHEN x > 3;

END LOOP;

-- EXIT后，从这接着执行

DBMS_OUTPUT.PUT_LINE('循环之后: x = ' || TO_CHAR(x));

END;

DECLARE

s PLS_INTEGER := 0;

i PLS_INTEGER := 0;

j PLS_INTEGER;

BEGIN

<<outer_loop>>

LOOP

i := i + 1;

j := 0;

<<inner_loop>>

LOOP

j := j + 1;

s := s + i * j; -- 将多种商品汇总

EXIT inner_loop WHEN (j > 5);

EXIT outer_loop WHEN ((i * j) > 15);

END LOOP inner_loop;

END LOOP outer_loop;

DBMS_OUTPUT.PUT_LINE ('商品汇总等于: ' || TO_CHAR(s));

END;

ITPub博客

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