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