17,086
社区成员
发帖
与我相关
我的任务
分享
create table testTri(id int,pid int);
insert into testTri values(1,0);
insert into testTri values(2,1);
insert into testTri values(3,1);
insert into testTri values(4,1);
select * from testTri;
create or replace Trigger tt
after delete on testTri
for each row
declare
PRAGMA AUTONOMOUS_TRANSACTION;
begin
dbms_output.put_line(:old.id);
update testTri set pid=0 where pid=:old.id;
commit;
end;
delete from testTri where id=1;