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

Popular Posts:

How do you handle change request? Normally change request are handled by preparing an Impact analysi...

Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...

What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...

What is synchronization and why is it important? With respect to multithreading, synchronization is ...

what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...