USING ROLLBACK

This will undo the operation.

This will be applied in two methods.

Ø  Upto previous commit

Ø  Upto previous rollback

Syntax:

Roll or roll work;

Or

Rollback or rollback work;

* While process is going on, if suddenly power goes then oracle will rollback the transaction.