Commit upto save point

[Geek_Guest]

Is there any possibilities to commit upto a savepoint?

For example:

1.Update emp .....
savepoint a
2.update emp ....
savepont b
3.update emp...
savepoint c


Now i want to commit upto savepoint b. Is it possible ? if yes how?

Question asked by visitor kanahavel

[susarlasireesha]

update emp.....

savepoint a;

update emp....

savepoint b;

update emp...

savepoint c;

ROLLBACK TO SAVEPOINT B

commit; Hope this will help u

[debasisdas]

Directly there is no such command. Savepoints are used along with Rollback command not with Commit command. Follow the steps as suggested in the previous post.

[sridharrganesan]

update emp.....
savepoint a;
update emp....
savepoint b;
update emp...
savepoint c;
ROLLBACK TO SAVEPOINT B
commit;

This will help to commit upto savepoint b