Please send your Questions & Answers or Feedback to ""

What is Transaction Processing in Oracle ?

A transaction is defined as a discrete unit of work in Oracle and consists of at least one SQL statement. The transaction completes when it is completely made permanent or committed, or it is completely undone or rolled back. Note that either the user executing the transaction or a malfunction of the database (e.g., due to inadequate space in a table) can roll back a SQL statement. If the user does the rollback, it is done explicitly using the rollback statement. The user, similarly, performs a commit by using the commit statement.In addition to the commit and rollback statements, users can use the save point statement, which will commit the results of a long transaction until a certain intermediate point only. If a program successfully completes and the user exists gracefully from SQL*Plus, the results are implicitly committed, even without the commit command.

Related Posts Plugin for WordPress, Blogger...

Flag Counter