ROLLBACK

Undo work done (transactional).

Syntax:

   ROLLBACK [WORK] [TO 'savepoint_text_identifier']
   ROLLBACK [WORK] [FORCE 'force_text']

FORCE - will manually rollback an in-doubt distributed transaction

"One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important." - Bertrand Russell

Related Commands:

COMMIT - Save Changes
LOCK TABLE
SAVEPOINT
- Save changes to a point
DBMS_FLASHBACK

Related Views:

 V$TRANSACTION
 V$TRANSACTION_ENQUEUE
 V$GLOBAL_TRANSACTION




Back to the Top

Simon Sheppard
SS64.com