EXIT WHEN
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博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1104276/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1104276/