Starting and Ending a Transaction

A transaction begins when one of the following events occurs:

• Connect to the database and perform a DML statement (an INSERT, UPDATE,or DELETE).
• A previous transaction ends and you enter another DML statement.

A transaction ends when:

• You perform a COMMIT or a ROLLBACK.
• You perform a DDL statement, such as a CREATE TABLE statement, or a DCL statement, such as a GRANT statement, in which case a COMMIT is automatically performed.
• You disconnect from the database.
• You perform a DML statement that fails, in which case a ROLLBACK is automatically performed for that individual DML statement.

1. Committing and Rolling Back a Transaction
2. Starting and Ending a Transaction
3. Savepoints
4. ACID Transaction Properties