[PL/SQL] LOOP话语例子

DECLARE    V_CNT   NUMBER := 100;BEGIN    DBMS_OUTPUT.ENABLE;        LOOP        INSERT INTO EMP(EMPNO, ENAME, HIREDATE)             VALUES (V_CNT, 'TEST' || TO_CHAR(V_CNT), SYSDATE);                     V_CNT := V_CNT + 1;                EXIT WHEN V_CNT > 110;    END LOOP;        DBMS_OUTPUT.PUT_LINE('数据输入完成');    DBMS_OUTPUT.PUT_LINE('输入了' || TO_CHAR(V_CNT - 100) || '个');END;/SQL>   SELECT * FROM EMP;EMPNO ENAME      JOB       MGR   HIREDATE            SAL       COMM      DEP----- ---------- --------- ----- ------------------- --------- --------- ---  100 TEST100                    19-11-2014 16:47:12                          101 TEST101                    19-11-2014 16:47:12                          102 TEST102                    19-11-2014 16:47:12                          103 TEST103                    19-11-2014 16:47:12                          104 TEST104                    19-11-2014 16:47:12                          105 TEST105                    19-11-2014 16:47:12                          106 TEST106                    19-11-2014 16:47:12                          107 TEST107                    19-11-2014 16:47:12                          108 TEST108                    19-11-2014 16:47:12                          109 TEST109                    19-11-2014 16:47:12                          110 TEST110                    19-11-2014 16:47:12      

?