Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Transaction

 

Starting and Ending a Transaction

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