04JulNotes

04JulNotes - insert into t1 values (1,10) insert into t1...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Lock for update able to be selected but not for updating or deleting select empno,ename from emp for update nowait corsor command current of cursor name cursor of c1 the other corsur try to change locked record that will be hang because of dead lock select sal from emp where empno =7369 for update of sal nowait update emp set ename='HHH' where empno=7369
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: insert into t1 values (1,10) insert into t1 values(30,20) insert into t1 values(3,30) insert into t1 values(45,40) insert into t1 values(57,50) insert into t1 values(6,60) declare t t1%rowtype cursor c1 is select * from t1 where e>f for update begin for t in c1 loop delete from where current of c1 insert into t1 values(t.f,t.e) end loop end...
View Full Document

Ask a homework question - tutors are online