TCL statement

In TCL(Transaction control language) we have,

• commit
• rollback
• savepoint

Commit:

To save DML statement we use commit. Just like save in text file.

SQL> commit;

Rollback:

To undo changes made by DML statement. Just like undo in text file.


SQL>rollback;


SavePoint;

To save a transaction at a point we use savepoint .