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.

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.

Answer / tulsi

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

Answer / rahul

used to recover data
that recently deleted

Answer / kotravel. b

To perform line by line transaction we r using save point

what is meant by tuning and tk proof?

2 Answers  

What is the cause of mutating table error and how can we solve it?

0 Answers  

how to use case expression? : Sql dba

0 Answers  

will function return more than one value how

9 Answers   Accenture,

What is input buffer in sql*plus?

0 Answers  

Is pl sql better than sql?

0 Answers  

How do you optimize a stored procedure in sql?

0 Answers  

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

What is the use of procedures?

0 Answers  

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

What is the difference between sum and count in sql?

0 Answers  

What are variables in pl sql?

0 Answers