create trigger score_tri
before insert or update on score
for each row
declare
cursor t_sor is
select count(1) cn,课程代号 from score group by 课程代号;
num number;
begin
for v_sor in t_sor loop
if v_sor.cn>=5 then
raise_application_error(-2000,v_sor.课程代号);
end if;
end loop;
end;
/
before insert or update on score
for each row
declare
cursor t_sor is
select count(1) cn,课程代号 from score group by 课程代号;
num number;
begin
for v_sor in t_sor loop
if v_sor.cn>=5 then
raise_application_error(-2000,v_sor.课程代号);
end if;
end loop;
end;
/
他用的是BEFORE INSERT