日期:2014-05-16 浏览次数:20879 次
DECLARE
i NUMBER;
BEGIN
LOOP
SELECT XUEXI_seq.NEXTVAL INTO i FROM DUAL;
INSERT INTO XUEXI(a1) VALUES (i);
EXIT WHEN i>=100;
END LOOP;
COMMIT;
END;
DECLARE
I NUMBER:=0;
BEGIN
WHILE I < 100 LOOP
I := XUEXI_SEQ.NEXTVAL;
INSERT INTO XUEXI (A1) VALUES (I);
COMMIT;
END LOOP;
END;