Transaction Control-TCL

By | November 7, 2013

statements are used to manage the changes made by DML statements

Some Examples

1)COMMIT-save work done
2)SAVEPOINT-identify a point in a transaction to which you can later roll back
3)ROLLBACK-restore database to original since the last COMMIT
4)SETTRANSACTION- Change transaction options like isolation level and what rollback segment to use.