休眠

[[Oracle APEX]]

DBMS_SESSION.SLEEP 和 DBMS_LOCK.SLEEP(5); – 暂停 5 秒

– https://www.cnblogs.com/bicewow/p/12418983.html – https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=168012928210610&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2577517.1&_afrWindowMode=0&_adf.ctrl-state=add25wxz4_4

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16



BEGIN

    DBMS_OUTPUT.PUT_LINE('Start ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    DBMS_LOCK.SLEEP(5); -- 暂停 5 秒
    DBMS_OUTPUT.PUT_LINE('End ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));

END;



BEGIN
    DBMS_OUTPUT.PUT_LINE('Start ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    dbms_session.sleep(5);
    DBMS_OUTPUT.PUT_LINE('End ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
END;

推荐 dbms_session