create table t1(id number,nm varchar2(100));
create table t2(id number,nm varchar2(100));
insert into t2 values(1,'n1');
CREATE OR REPLACE TRIGGER test
before update ON t1
FOR EACH ROW
declare
<strong>PRAGMA AUTONOMOUS_TRANSACTION;
</strong>BEGIN
insert into t2
select * from t1 where id = :old.id;
commit;
END;
update t1 set t1.id=10 where t1.id=1;
commit;