<<Previous Next>>
Oracle - Explain the purpose of Rollback
and commit statements. - Feb 23, 2010 at 11:00 PM by
Rajmeet Ghai
Explain the purpose of Rollback and commit
statements.
ROLLBACK: Rollback is used to rollback or
undo all the work done in the current transaction.
Example:
The example below undoes all changes committed until
the save point.
ROLLBACK TO SAVEPOINT savepoint_name
COMMIT: Commit is used to save the work done in
the current transaction.
Example:
The example below saves all
the work done in the transaction
COMMIT WORK
Oracle - Explain the purpose of Rollback and
commit statements. - April 10, 2009
at 11:00 AM
Explain the purpose of Rollback and commit
statements.
Rollback and commit statement controls
database transactions. Both statements ensure the data consistency.
They allow users to preview the data before making permanent.
Also read
The parser scans the statement and breaks it into logical units
such as keywords, identifiers and operators, A query or a sequence
tree is built using the units above. This is done to transform the
source data into the format required by the result set.............
READ COMMITTED: If row locks are obtained by a certain
transaction, then any other transaction that contains DML needs to
wait until the row locks have been released by that particular
transaction.............
Rollback segments undo changes when a transaction is rolled back,
they also ensure that transactions leave the uncommitted changes
unnoticed..............
Rollback Segment in oracle is used to store "undo" information
temporarily..........
|
