CREATE TRIGGER TRI_AAA
AFTER DELETE
ON bbs2
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
DELETE bbs1 WHERE :OLD.bbs_delis = 1 and bbs_delis = 1;
END;
/
AFTER DELETE
ON bbs2
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
DELETE bbs1 WHERE :OLD.bbs_delis = 1 and bbs_delis = 1;
END;
/
[( argument [ IN | OUT | IN OUT ] [NOCOPY] datatype
[, argument [ IN | OUT | IN OUT ] [NOCOPY] datatype]...
)
]
[invoker_rights_clause] { IS | AS } { pl/sql_subprogram_body | call_spec };
begin
delete from bbs2 where bbs_delis=bbs_del;
delete from bbs1 where bbs_delis=bbs_del;
end;
after delete on bbs2
referrencing old as old_bbs2
for each row
begin
delete from bbs1 where bbs1.bbs_detlis = :old_bbs2.bbs_delis;
commit;
end tri_bbs;
/