触发器

 create or replace trigger over_tir
  before insert on tritest
  for each row
  when (new.stuid<2000)
 begin
 if :new.sindex>=30 then
 raise_application_error(-20001,'超出这个范围');
end if;
end;
/