取消插入触发器

取消插入触发器

create trigger mytrg before insert on mytable

for each row

begin

  if ... then

     raise_application_error(-20099,'can not insert for reason of ....');

  end if;

end;