What are the usage of SAVEPOINTS?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

571


What is orm in sql?

541


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6090


What will you get by the cursor attribute sql%notfound?

596


what is not null constraint? : Sql dba

555






How do you write a complex sql query?

591


differentiate between float and double. : Sql dba

563


what does the t-sql command ident_incr does? : Transact sql

606


What is the difference between a query and a report?

524


Is primary key always clustered index?

541


explain the difference between delete , truncate and drop commands? : Sql dba

553


Is foreign key mandatory?

559


What is the sql case statement?

582


what is a table in a database ? : Sql dba

548


What are all types of user defined functions?

532