Commit upto save point

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?

[B]Question asked by visitor kanahavel[/b]

update emp.....

savepoint a;

update emp....

savepoint b;

update emp...

savepoint c;

ROLLBACK TO SAVEPOINT B

commit; Hope this will help u

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

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