create or replace trigger tri_update_status_UpdateTime
after UPDATE -- update 触发
ON receive
FOR EACH ROW
DECLARE
curr_sql varchar2(128) ;
BEGIN
curr_sql := 'update sdunicommain.listener l set l.status =2 where l.itemid ='||:new.id ;
if :new.overflag = 1 then
curr_sql := 'update sdunicommain.listener l set l.status =3 where l.itemid ='||:new.id ;
end if;
execute immediate curr_sql ;
end tri_update_statusAndUpdateTime ;
after UPDATE -- update 触发
ON receive
FOR EACH ROW
DECLARE
curr_sql varchar2(128) ;
BEGIN
curr_sql := 'update sdunicommain.listener l set l.status =2 where l.itemid ='||:new.id ;
if :new.overflag = 1 then
curr_sql := 'update sdunicommain.listener l set l.status =3 where l.itemid ='||:new.id ;
end if;
execute immediate curr_sql ;
end tri_update_statusAndUpdateTime ;