Oracle SQL Transaction Management

There is no Oracle SQL statement to explicitly start a new transaction. Oracle server implicitly starts a new transaction with the following two conditions:

* The first executable statement of a new user session will automatically start a new transaction.
* The first executable statement after a previous transaction has been ended will automatically start a new transaction.

There are several ways a current Oracle transaction can be ended:

* Running the COMMIT statement will explicitly end the current transaction.
* Running the ROLLBACK statement will explicitly end the current transaction.
* Running any DDL statement will implicitly end the current transaction.
* Disconnecting a user session will implicitly end the current transaction.
* Killing a user session will implicitly end the current transaction.