Explain the SAVEPOINT statement.
With SAVEPOINT, only part of transaction can be undone. In PL/SQL, the SAVEPOINT statement is used to set a point within the current transaction to which you can later roll back. This allows you to create a named point in your transaction where you can later return if needed, rather than rolling back the entire … Read more