I have a query on set transaction. Set transaction 3; delete emp; delete dept where deptno = 30; rollback; update ename = 'krishna' emp where ename = 'smith'; can anyone explain the sequence of processing of above statements. After 2 delete statements i made rollback, whether update statement will be the first query or the third query. With regards, chaitanya.

In first transaction,data was delete from emp,
second transaction--deptno 30 data was deleted from dept table
but u made rollback statement ,so above transactions are roll backed to the last commit point.
then third statement -- update ename smith to krishna then fire comment ,
commit the last transaction changes.

__________________
Sireesha