What is TCL? / List of operations that can be performed by Transaction Control Language / TCL examples / Different commands of TCL / What is Transaction Control Language? / Define TCL
Transaction Control Language (TCL)
- Insertion of a record in a table/multiple tables
- Modification of the values in a table
- Deletion of records in a table/multiple tables
- When you deposit some money in your account, your deposit will modify the data in your record. This is treated as single transaction.
- If you would like to withdraw some money from your account from the bank, your withdrawal performs one modification in your record. In some cases, the operation that you performed might by logged in another table for maintaining a history of transaction. This involves an insertion. Here, both modification and insertion put together considered as single transaction.
- If you would like to transfer some money from your account to your friend’s then your transfer involves modification in your record and your friend’s record. Here, modification of values in both the records treated as single transaction.
- Commit – to permanently save the changes that are executed as part of a transaction in a database.
- Rollback – to undo the changes that are made on a database through a transaction.
- Savepoint - A SAVEPOINT is a point in a transaction that you can use to roll the transaction back to a certain point without rolling back the entire transaction.