TCL - Transaction Control Language

SAVEPOINT

A SQL statement that marks a point in a session. Future uses of the ROLLBACK statement may choose to restore the database to the point marked by a SAVEPOINT statement.

TCL keywords

COMMIT ROLLBACK SAVEPOINT

[Many DML Operations] SAVEPOINT A [Many DML Operations] ROLLBACK TO A

The syntax flow of using TCL

TCL

Transaction Control Language

ROLLBACK

_____ any DML operations between two COMMIT statements will be completely erased (something like Ctrl + Z that will stop only when it reaches last time you opened the specific file). Committed transactions cannot be rollbacked.

COMMIT

_____ any DML operations that were executed before the statements will be persisted permanently.

to manage transactions within a relational database.

what are TCL statements used for