What are the usage of SAVEPOINTS?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

5 Answers
15678 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the usage of SAVEPOINTS?..

Answer / deva

Save points are used to mark our transactions. Then later
on, down the line, we can roll back to that particular
transaction and roll back can be issued to that particular
point.

Is This Answer Correct ?

32 Yes

2 No

What are the usage of SAVEPOINTS?..

Answer / bindhu

Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
SAVEPOINT statement.

Is This Answer Correct ?

19 Yes

4 No

What are the usage of SAVEPOINTS?..

Answer / tulsi

1)In savepoint we can only rollback to every point the
savepoint is issued but we cant do commit at every savepoint

Is This Answer Correct ?

16 Yes

4 No

What are the usage of SAVEPOINTS?..

Answer / rahul

used to recover data
that recently deleted

Is This Answer Correct ?

0 Yes

0 No

What are the usage of SAVEPOINTS?..

Answer / kotravel. b

To perform line by line transaction we r using save point

Is This Answer Correct ?

4 Yes

5 No

Post New Answer