create or replact trigger tr_ts
after delete on ts
for each row
begin
delete from ts_sub where p_id=:old.p_id;
end;
/
after delete on ts
for each row
begin
delete from ts_sub where p_id=:old.p_id;
end;
/
调试欢乐多
after delete on ts
for each row
declare
-- local variables here
begin
delete from ts_tt where id=:old.id;
end del_ts;
after delete on ts
for each row
Begin
delete from ts_sub
where p_id=:old.id;
end Del_Ts_Ts_sub;
where p_id=:old.id
的old.id是什么意思呢,,,????????
delete from ts where id=2;
中的id呢??另外,bzszp(www.bzszp.533.net) 的
delete from ts_sub where p_id=:old.p_id;
要改为:delete from ts_sub where p_id=:old.id;