Transaction Control Language
A Transaction Control Language (TCL) is a computer language and a subset of SQL, used to control transactional processing in a database. A transaction is logical unit of work that comprises one or more SQL statements, usually a group of Data Manipulation Language (DML) statements.
Examples of TCL commands include:
- COMMIT to apply the transaction by saving the database changes.
- ROLLBACK to undo all changes of a transaction.
- SAVEPOINT to divide the transaction into smaller sections. It defines breakpoints for a transaction to allow partial rollbacks.
See also
This article is issued from Wikipedia - version of the 2/23/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.