Transactions in applications

Transactions are sets of atomic SQL statements. Either all statements in the transaction are executed, or none. This section describes a few aspects of transactions in applications.

• Autocommit and manual commit mode
  Database programming interfaces can operate in either manual commit mode or autocommit mode.
• Isolation level settings
  You can set the isolation level of a current connection using the isolation_level database option.
• Cursors and transactions
  In general, a cursor closes when a COMMIT is performed. There are two exceptions to this behavior.