satya ranjan pal

• Jun 5th, 2006

 

Savepoints let you undo selected changes within a transaction. Your application can set any number of savepoints using SQL SAVEPOINT statements, and then use SQL ROLLBACK TO SAVEPOINT statements to indicate which changes within the unit of work to undo. When the application no longer uses a savepoint.

example:

savepoint A

..

..

savepoint b

...

..

rollback to savepoint

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao 

• Aug 2nd, 2006

 

good question.

remember... you are doing huge work. means assume that you have execute 100 queties. ok . you already finished 50 queries. after executing the 51 query you thaught there is a mistic. what you will do. if you rollback then all the work will be rollbacked.

to overcome this problem they introduced this savepoint consept. after executing some work put one flag and after that one flag. like that. if you want to rollback it then rollback to particular flag.

rollback to savepoint1....

thanks & Regards

Madhu D.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

 

nice reply sir