Ways to Start a New Transaction in Oracle

Q

How To Start a New Transaction in Oracle?

✍: FYIcenter.com

A

There is no 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.

 

Understanding SQL Transaction Management in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 141👍, 0💬