Oracle触发器

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 ;