oracle DBMS_LOCK.SLEEP()的使用

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