What Is The Purpose Of Save Points In Oracle Database?

1.	What Is The Purpose Of Save Points In Oracle Database?
Answer» SAVE POINTS are used to DIVIDE a transaction into smaller phases. It enables rolling back part of a transaction. Maximum 5 save points are allowed in ORACLE Database. Whenever an error is encountered, it is possible to rollback from the point where the SAVEPOINT has been saved.

Answer»

SAVE POINTS are used to DIVIDE a transaction into smaller phases.
It enables rolling back part of a transaction.
Maximum 5 save points are allowed in ORACLE Database.
Whenever an error is encountered, it is possible to rollback from the point where the SAVEPOINT has been saved.

Discussion