Starting and Ending a Transaction : Introduction « Transaction « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Transaction
  3. Introduction

As mentioned, transactions are logical units of work you use to split up your database activities.

A transaction has both a beginning and an end.

A transaction begins when one of the following events occurs:

  1. You connect to the database and perform the first DML statement.
  2. A previous transaction ends and you enter another DML statement.

A transaction ends when one of the following events occurs:

  1. You perform a COMMIT or a ROLLBACK statement.
  2. You perform a DDL statement, such as a CREATE TABLE statement, in which case a COMMIT is automatically performed.
  3. You perform a DCL statement, such as a GRANT statement, in which case a COMMIT is automatically performed.
  4. You disconnect from the database.
  5. If you exit SQL*Plus normally by entering the EXIT command, a COMMIT is automatically performed for you.
  6. If SQL*Plus terminates abnormally, a ROLLBACK is automatically performed.
  7. You perform a DML statement that fails, in which case a ROLLBACK is automatically performed for that individual DML statement.

Quote from:

Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

# Paperback: 608 pages

# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)

# Language: English

# ISBN-10: 0072229810

# ISBN-13: 978-0072229813

35.1.Introduction
35.1.1.Starting and Ending a Transaction
35.1.2.ACID Transaction Properties, Transaction Locking and Transaction Isolation Levels