Ends a transaction and undoes all changes you made since that
transaction began. The ROLLBACK statement also:
o Closes all open cursors (with the exception of WITH HOLD
cursors)
o Releases all row locks
o Performs a checkpoint operation if fast commit processing is
enabled
The ROLLBACK statement affects:
o All open databases included in the current transaction
o All changes to data made with SQL data manipulation statements
(DELETE, UPDATE, and INSERT)
o All changes to data definitions made with SQL data definition
statements (ALTER, CREATE, DROP, RENAME, GRANT, and REVOKE)
Additional Information:
explode
extract