TCL Commands

In this sub section, let us learn the usage of below commands in detail.

1. COMMIT

COMMIT statement is used to save all the changes made to the database in the current transaction.

Syntax:

COMMIT;

2. ROLLBACK

ROLLBACK statement is used to revert the changes made to a database table in the current transaction.

Syntax:

ROLLBACK;

3. SAVE

SAVE statement is used to define a identifier which points to the named transaction savepoint.

Syntax:

SAVE [TRANSACTION] savepoint_name;