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

[ label ] WHILE condition LOOP

    statements

END LOOP [ label ];

DECLARE

    done  BOOLEAN := FALSE;

BEGIN

    WHILE done LOOP

        DBMS_OUTPUT.PUT_LINE ('該行不會輸出.');

        done := TRUE;  --賦值語句不會執行

    END LOOP;

    WHILE NOT done LOOP

        DBMS_OUTPUT.PUT_LINE ('你好!');

        done := TRUE;

    END LOOP;

END;

LOOP

    statements

    EXIT WHEN condition;

END LOOP;