Saturday, 6 February 2016

Transaction Control Language (TCL)

Transaction Control Language (TCL): Transaction:A transaction is a set of sql statements which Oracle treat as a Single unit.The following scenarios TCL commands comes into the picture. If any transaction failed then rollback all the remain statements All the statements execute successfully None of...