Transaction Control
The commands used to manage transactions are as follows:
- BEGIN TRANSACTION – This command marks the start of each transaction.
- COMMIT – This command saves the changes to the database in a permanent manner.
- ROLLBACK – This command reverses any modifications, returning them to their original condition.
- SAVEPOINT – this command enables us to roll back transactions in parts rather than all at once by establishing points within groups of transactions.
- RELEASE SAVEPOINT – This command is used to delete an existing SAVEPOINT.
- SET TRANSACTION – This command gives us the ability to give a transaction a name and specify whether we want it to be read-only, read/write, or to belong to a certain rollback segment.