How To Start a New Transaction

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

✍: FYIcenter.com

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, 5006👍, 0💬

Popular Posts:

What is Service Oriented architecture? “Services” are components which expose well defined interface...

What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...

How To Get the Uploaded File Information in the Receiving PHP Script? Once the Web server received t...

How can I implement a variable field width with printf? That is, instead of something like %8d, I wa...

What metrics will you look at in order to see the project is moving successfully? Most metric sets d...