FANDOM


A Transaction Controls Language (TCL) is used to converse (more usually, to issue commands) about transactions on data in a DBMSes.

Example data transaction-related statements in the SQL language, for relational DBMSes:

  • COMMIT - save work done
  • SAVEPOINT - identify a point in a transaction to which you can later roll back
  • ROLLBACK - restore database to original since the last COMMIT
  • SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use

See also: DDL, DML, DCL.