Question

Write the use of Savepoint command with an example?

SAVEPOINT command

Answer 1

The SAVEPOINT command is used to temporarily save a transaction so that you can rollback to the point whenever required. The different states of our table can be saved at anytime using different names and the rollback to that state can be done using the ROLLBACK command.

SAVEPOINT savepoint_name;

UPDATE Student SET Name = ‘Mini ’ WHERE 

Admno=105;

SAVEPOINT A;