OraFAQ Forum: Training & Certification » Question about Rollback

Home » Other » Training & Certification » Question about Rollback

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question about Rollback [message #361701]

Thu, 27 November 2008 10:50

registereduser
Messages: 52
Registered: June 2008
Location: Toronto

Member

DELETE FROM tbl WHERE id = 3;
SAVEPOINT a;
UPDATE tbl SET col_1 = 5 WHERE id = 4;
ROLLBACK TO a;
ROLLBACK;

My question is whether "DELETE FROM tbl WHERE id = 3" has been done? Thanks.

Report message to a moderator

Re: Question about Rollback [message #361702 is a reply to message #361701]

Thu, 27 November 2008 11:18

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

The first ROLLBACK will undo the UPDATE and the second will undo the DELETE.

Best regards.

Frank

Report message to a moderator

Re: Question about Rollback [message #361709 is a reply to message #361701]

Thu, 27 November 2008 11:47

registereduser
Messages: 52
Registered: June 2008
Location: Toronto

Member

Thanks Frank.

That removed a doubt for me. According to text books, rollback constitutes a commit, which literally means the “rollback” only rollback to the specific savepoint and commit all statements before that savepoint.

Report message to a moderator

Re: Question about Rollback [message #361710 is a reply to message #361709]

Thu, 27 November 2008 12:01

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't know which book you read but either you misunderstood it either it is plain wrong.
A rollback is NOT a commit in any way but as a commit it releases locks.

Regards
Michel

Report message to a moderator

Re: Question about Rollback [message #362302 is a reply to message #361710]

Mon, 01 December 2008 14:17

registereduser
Messages: 52
Registered: June 2008
Location: Toronto

Member

Thanks a lot.

Report message to a moderator

Previous Topic:	How to write this procedure?
Next Topic:	1Z0-146

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 17:57:36 CDT 2024