create trigger delbiao12 on biao1 for delete as delete biao2 where id=deleted.id
create trigger tb1_after_delete after delete on tb1 for each row begin delete tb1 where id= :old.id; end; /
owlbirdwill()还是sql server的语法 KingSunSha(弱水三千)的可以
这用级联删除也可以实现 create table aa (id number(5) primary key, name varchar2(8));create table bb (id number(5) primary key references aa(id) on delete cascade);当delete from aa时,在表bb中相应的记录也被同时删除.
on biao1
for delete
as
delete biao2
where id=deleted.id
after delete on tb1
for each row
begin
delete tb1 where id= :old.id;
end;
/
KingSunSha(弱水三千)的可以
create table aa
(id number(5) primary key,
name varchar2(8));create table bb
(id number(5) primary key references aa(id) on delete cascade);当delete from aa时,在表bb中相应的记录也被同时删除.