PLSQL Language Referenc-PL/SQL控制語句-迴圈語句-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;