触发器_template

//触发器

create or replace trigger 触发器名称 before insert on 表名称

for each row

declare

begin 

if :NEW.id like '50%' and :New.display <> '0' and

   :NEW.state <> '1' then

   :NEW.display :=0;

   :NEW.state :=1

   :NEW.person :='张三'

end if;

end;