Krishna Chaitanya Reddy.R

• Sep 1st, 2005

 

The Oracle RDBMS provides a transaction model based on a unit of work. The PL/SQL language supports most, but not all, of the database model for transactions (you cannot, for example, ROLLBACK FORCE). Transactions begin with the first change to data and end with either a COMMIT or ROLLBACK.  
 
COMMIT makes the database changes permanent and visible to other database sessions.  
 
ROLLBACK undoes the changes made in the current transaction either to the beginning of the transaction or to a savepoint. A savepoint is a named processing point in a transaction, created with the SAVEPOINT statement. Rolling back to a savepoint is a partial rollback of a transaction, wiping out all changes (and savepoints) that occurred later than the named savepoint. 
 

Mustafa

• Sep 28th, 2007

 

Ans: Commit and Rollbacks are the terms used in Oracle database, Commit is when a request is updated into the datebase tables completely then it is called as Commit, Rollback is nothing but in case of any errors or if a request is not updated into the datebase tabel its called as Rollback .