create table DEMO(id int primary key, a int not null, b int);

insert into DEMO values(1,1,1);

insert into DEMO values(2,2,2);

commit;

update DEMO set b=b+1 where a=1;

declare pragma autonomous_transaction; r sys_refcursor; begin -- read access the row that is not locked open r for select * from DEMO where a=2; dbms_sql.return_result(r); -- read access the row that is locked open r for select * from DEMO where a=1; dbms_sql.return_result(r); -- write access on the row that is not locked delete from DEMO where a=2; -- write access on the row that is locked delete from DEMO where a=1; commit; end; /