oracle計(jì)算時(shí)間差天數(shù) oracle觸發(fā)器中定時(shí)執(zhí)行sql?
oracle觸發(fā)器中定時(shí)執(zhí)行sql?定時(shí)plsql代碼如下此代碼已計(jì)算定時(shí)(目前定時(shí)20分)DECLARE l_datediff NUMBER --時(shí)間差 l_bein DATE --程序
oracle觸發(fā)器中定時(shí)執(zhí)行sql?
定時(shí)plsql代碼如下此代碼已計(jì)算定時(shí)(目前定時(shí)20分)DECLARE l_datediff NUMBER --時(shí)間差 l_bein DATE --程序執(zhí)行時(shí)間 l_time NUMBER := 20 --定時(shí)BEGIN dbms_output.put_line(to_char(SYSDATE,"yyyy-mm-dd hh24:mi:ss")) l_bein := SYSDATE LOOP SELECT SYSDATE - l_bein INTO l_datediff FROM dual EXIT WHEN l_datediff >= l_time/(24*60) --計(jì)算時(shí)分秒 END LOOPEND