TRANSACTION CONTROL LANGUAGE (TCL) (Commit, Rollback, Savepint)

TRANSACTION CONTROL LANGUAGE (TCL) (Commit, Rollback, Savepint)

The COMMIT Command
The commit command is used to make changes to data (DML) permanently
SQL> Commit;

The ROLLBACK Command

The ROLLABCK command is used to discard parts or all the work the user has done in the current transaction
To undo the previos command from after the commit .

SQL> Rollback;

The SAVEPOINT Command
Savepoints statements are used to discard or commit all the changes upto a point

SQL> Savepoint a ;
SQL> Rollback to savepoint a ;