Home » SQL & PL/SQL » SQL & PL/SQL » Rollback
Rollback [message #202817] Sun, 12 November 2006 23:38 Go to next message
ashutosh_1116
Messages: 5
Registered: November 2006
Location: India
Junior Member

Suppose we have created four savepoint i.e s1,s2,s3 and s4.
I want to Rollback s2 to s1.How we can Rollback this?
Re: Rollback [message #202825 is a reply to message #202817] Mon, 13 November 2006 00:20 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Without rolling back savepoints s3 and s4, you can't.

Savepoints are cumulative.

Search the doco for AUTONOMOUS TRANSACTION. It might be what you are looking for.

Ross Leishman
Re: Rollback [message #203160 is a reply to message #202825] Tue, 14 November 2006 02:41 Go to previous message
ashutosh_1116
Messages: 5
Registered: November 2006
Location: India
Junior Member

Thanks for answering me.
Previous Topic: select date
Next Topic: ORA-00979: not a GROUP BY expression
Goto Forum:
  


Current Time: Wed Dec 07 20:49:43 CST 2016

Total time taken to generate the page: 0.16129 seconds