Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
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 |