CREATE OR REPLACE TRIGGER MSG.TRG_FLOW_INSTANCE
before insert on flow_instance
for each row
begin
delete from flow_instance
where (PROCESS_INS_OID, FLOW_INS_OID) in
(select PROCESS_INS_OID, FLOW_INS_OID
from flow_instance
where eventid = :new.eventid
and seq = :new.seq
and owner = :new.owner
and realowner = :new.realowner
and flowid = :new.flowid
and GETDATE + 0.00694> :new.GETDATE
and flowid != 'F017');
end;使用没有问题 但是GETDATE + 0.00694 这个到底是什么意思? 求教~~!!
把数据贴出来看看
--默认是天,就是 GETDATE + 0.00694天,具体什么含义看你自己的业务。[SYS@myoracle] SQL>select 0.00694*86400 from dual;0.00694*86400
-------------
599.616 --约等于600秒[SYS@myoracle] SQL>select 0.00694*1440 from dual;0.00694*1440
------------
9.9936 --约等于10分钟[SYS@myoracle] SQL>select 0.00694*24 from dual;0.00694*24
----------
.16656 --约等于0.17小时