//触发器
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;
//触发器
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;