Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

Oracle - Transactions

This article describes transactions in Oracle 11g and earlier.

Transactions

In Oracle, transactions are implicit as defined by the ANSI standard. This means that a transaction is automatically initiated after connection, COMMIT or ROLLBACK statements.

The transaction ends with a corresponding COMMIT or ROLLBACK statements. The changes are committed to the database only when a COMMIT statement is executed.

Oracle - Transactions in Other Databases

Database Transactions Notes
SQL Server SQL Server Transactions Transactions are explicit by default - BEGIN TRAN required to start a transaction
Sybase ASE Sybase ASE Transactions Transactions are explicit by default - BEGIN TRAN required to start a transaction


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

sqlways/oracle/transactions.txt · Last modified: March 20, 2013, 04:00:07 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement