From : http://hi.baidu.com/dbachina/blog/item/12134e4ea50aabced1c86a57.html
[@more@]1创建测试表
CREATE TABLE tbl_tt (ID NUMBER(4),addtime DATE);
2开始测试
BEGIN
FOR i IN 1 .. 10
LOOP
INSERT INTO tbl_tt
VALUES (i, SYSDATE);
COMMIT;
DBMS_LOCK.sleep (5);
END LOOP;
END;
/
3查询数据
ID ADDTIME
---------- -------------------
1 2008-01-14 13:10:20
2 2008-01-14 13:10:26
3 2008-01-14 13:10:31
4 2008-01-14 13:10:36
5 2008-01-14 13:10:41
6 2008-01-14 13:10:46
7 2008-01-14 13:10:51
8 2008-01-14 13:10:56
9 2008-01-14 13:11:01
10 2008-01-14 13:11:07
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66634/viewspace-1013085/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/66634/viewspace-1013085/