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; [
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;
[