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:
You connect to the database and perform the first DML statement.
A previous transaction ends and you enter another DML statement.
A transaction ends when one of the following events occurs:
You perform a COMMIT or a ROLLBACK statement.
You perform a DDL statement, such as a CREATE TABLE statement, in which case a COMMIT is automatically performed.
You perform a DCL statement, such as a GRANT statement, in which case a COMMIT is automatically performed.
You disconnect from the database.
If you exit SQL*Plus normally by entering the EXIT command, a COMMIT is automatically performed for you.
If SQL*Plus terminates abnormally, a ROLLBACK is automatically performed.
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