Saturday 6 June 2015

What are TCL statements?

TCL(Transaction Control Language) statements manage the change made by DML statements, and group DML statements into transactions. These are:
  • COMMIT- used to make a transaction's changes permanent
  • ROLLBACK- used to undo changes in a transaction, either since the transaction started or since a savepoint
  • SAVEPOINT- used to set point to which a transaction can be rolled back
  • SET TRANSACTION- used to establish properties for a transaction

No comments:

Post a Comment