Commit, Rollback and Savepoint in oracle
Explain Commit, Rollback and Savepoint.
For a COMMIT statement, the following is true:
- Other users can see the data changes made by the transaction.
- The locks acquired by the transaction are released.
- The work done by the transaction becomes permanent.
A ROLLBACK statement gets issued when the transaction ends, and the following is true.
- The work done in a transition is undone as if it was never issued.
- All locks acquired by transaction are released.
It undoes all the work done by the user in a transaction. With SAVEPOINT, only part of transaction can be undone.
Advertising