Transaction Control (TCL) commands

by satheesh 2010-01-28 20:01:47

Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.

* 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

Tagged in:

704
like
0
dislike
0
mail
flag

You must LOGIN to add comments