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.

 

Ways to End the Current Transaction in Oracle

What Is a Transaction in Oracle

Understanding SQL Transaction Management in Oracle

⇑⇑ Oracle Database Tutorials

2019-09-16, 1732🔥, 0💬