create or replace trigger tri_delete_b
after delete on a
for each row
begin
delete from b where b.col1=:old.col1 and b.col2=:old.col2 and....
end;
after delete on a
for each row
begin
delete from b where b.col1=:old.col1 and b.col2=:old.col2 and....
end;
不过oracle支持级联删除语法,如果可以的话你不妨试一下。
对A,B表的主键设外键on delete cascade
不过oracle支持级联删除语法,如果可以的话你不妨试一下。
对A,B表的主键设外键on delete cascade
AFTER INSERT OR UPDATE ON STUDENTS_FINES
FOR EACH ROW
BEGIN
IF:NEW.sf_fine>10 THEN
UPDATE students
SET student_bl_status='F'
WHERE students.student_id = :NEW.sf_student_id;
ELSE
UPDATE students
SET student_bl_status='T'
WHERE students.student_id = :NEW.sf_student_id;
END IF;
END;