-
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?
Question asked by visitor kanahavel
-
Expert Member
Re: Commit upto save point
update emp.....
savepoint a;
update emp....
savepoint b;
update emp...
savepoint c;
ROLLBACK TO SAVEPOINT B
commit; Hope this will help u
-
Re: Commit upto save point
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.
-
Re: Commit upto save point
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules