Transactions

What are transactions, how to begin transactions, hot to end and cancel them?

BEGIN WORK - begin transaction

Syntax

Description:

    Marks the begin of an transaction, a set of SQL commands, that can be undo in error case.

COMMIT WORK - end the transaction

Syntax

Description:

    Marks the end of an transaction, a set of SQL commands, that can be undo in error case.

ROLLBACK WORK - cancel the transaction

Syntax

Description:

    Undo all SQL commands of an transaction.