What are the usage of SAVEPOINTS?

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

More SQL PLSQL Interview Questions

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  


How to move files from one directory to another in pl sql?

0 Answers  


How to test for null values?

0 Answers  


How to call DDL statements from pl/sql?

5 Answers  


how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  






I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  


Do prepared statements prevent sql injection?

0 Answers  


What found sql?

0 Answers  


What is cursor in pl sql?

0 Answers  


Which is the best place to learn hadoop?

1 Answers  


What is crud stand for?

0 Answers  


write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  


Categories