skip to main content
Non-Supported SQL-92 functionality : Transaction control statements : ROLLBACK
 

ROLLBACK

This statement undoes (rolls back) work done in the current transaction.

Syntax 

ROLLBACK

Example 

UPDATE emp SET sal = sal-1000 WHERE empno=101
ROLLBACK