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

Explain the savepoint statement.

610


How can a function retun more than one value in oracle with proper example?

592


Do we need to create index on primary key?

471


Can we use having without group by in sql?

557


What is error ora-12154: tns:could not resolve the connect identifier specified?

595






What pl/sql package consists of?

647


What is java sql package?

545


How delete all data from all tables in sql?

544


Show the two pl/sql cursor exceptions.

622


What is compilation error in pl sql?

513


What are pl sql data types?

555


What is difference between db2 and sql?

537


What is a field in a database?

578


What is the execution plan in sql?

564


Can a table contain multiple primary key’s?

637