create or replace trigger trig_emp
before insert or update of operateinfoid on t_operatorinfo
for each row
when (new.operateinfoid > 1)
begin
:new.operateinfoid := 1;
end trig_emp;
before insert or update of operateinfoid on t_operatorinfo
for each row
when (new.operateinfoid > 1)
begin
:new.operateinfoid := 1;
end trig_emp;