What is the difference between ROLLBACK and ROLLBACK TO statements in

1.	What is the difference between ROLLBACK and ROLLBACK TO statements in PL/SQL?
Answer» ROLLBACK command is USED for rolling back all the CHANGES from the BEGINNING of the transaction. ROLLBACK TO command is used for undoing the transaction only till a SAVEPOINT. The transactions cannot be rolled back before the SAVEPOINT and hence the transaction remains ACTIVE EVEN before the command is specified.

Discussion