What are the usage of SAVEPOINTS?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I use google cloud in sql?

525


What is cartesian join in sql?

547


Define tables and fields in a database

637


What is vector point function?

553


How do you write an index?

517






What are the datatypes available in pl/sql ?

597


What problem one might face while writing log information to a data-base table in pl/sql?

548


What is on delete set null?

553


What is an exception in PL/SQL? What are the two types of exceptions?

616


Differentiate between sga and pga.

652


How do you go back in sql?

519


When is the update_statistics command used?

564


Why do we use %rowtype & %type in plsql?

589


What is dynamic query?

528


What is nvarchar max in sql?

567