How To Start a New Transaction

Q

How To Start a New Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management

✍: 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.

2007-04-18, 4242👍, 0💬