Commit, Rollback and Savepoint in oracle

Published on by LakshmiSaahul,Dhana Royal

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
To be informed of the latest articles, subscribe:
Comment on this post