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

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