What are the usage of SAVEPOINTS ?

SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

Interview Candidate
Sep 7th, 2004
3
2167

SQL Plus

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 8th, 2006

savepoint is used to give some break points between multiple transactions so that if some transaction is required to be rolledback then some of transaction will still available in buffer. commit will save the data and remove all savepoints