oracle DBMS_LOCK.SLEEP()的使用

oracle DBMS_LOCK.SLEEP()的使用 

 http://blog.csdn.net/ikikik2002/article/details/5209536            

2010-01-18 21:13 2513人阅读 评论(0) 收藏 举报

oracle insert 测试 table date

一

、執行 ORACLE_HOME/rdbms/admin/dbmslock.sql 来创建 dbms_lock;

-在DBA身分下grant execute on dbms_lock to USERNAME;

-執行測試代碼

begin
dbms_output.put_line(to_char(sysdate,'yyyymmddhh24miss'));
dbms_lock.sleep(60);
dbms_output.put_line(to_char(sysdate,'yyyymmddhh24miss'));
end;

----&gt

20090728092027
20090728092129

 

 

二

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/27573546/viewspace-760707/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27573546/viewspace-760707/