In Oracle, the ROLLBACK
statement is used to undo all changes into the database table for the current transaction.
To undo all changes into the database table, use the following syntax:
Parameters:
WORK: It ROLLBACK with or without the WORK parameter will result in the same outcome.
TO SAVEPOINT : This ROLLBACK statement undoes all changes for the current session up to the savepoint.
FORCE : It is used to force the rollback of a transaction that may be corrupt or in doubt.
Note:
In the above example shows that how to issue a rollback in Oracle using the ROLLBACK statement.
Note:
In the above example shows that how to use the ROLLBACK to a specific savepoint.