create_trigger_dele_student.sql

一个挺好的招生管理系统

create or replace trigger delete_student
before delete on student
for each row
begin
delete from score where 号码=:old.编号;
if(:old.录取状态=1) then
update college set 录取人数=录取人数-1 where 院校编号=:old.录取院校;
end if;
end;
/