Tag Archives: rollback

Transaction Control-TCL

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.