What is SAVE POINT ?

Answer Posted / shilpa chandramohanan

A savepoint is a marker within the transaction used for
partial rollback. As changes are made in a transaction, we
can create SAVEPOINTs to mark different points within the
transaction. If we encounter an error, we can rollback to a
SAVEPOINT or all the way back to the beginning of the
transaction.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to install oracle database 10g xe?

562


What is a tns file?

500


What is the difference between postgresql and oracle?

503


What is the quickest way to fetch the data from a table?

566


What is a tns service name?

534






How will you write a query to get a 5th rank student from a table student_report?

1374


What are the various types of snapshots ?

562


How would you change old and new values in an insert, delete and update triggers?

541


What is set operator oracle?

526


What is bulk copy or bcp in oracle?

606


Can we create database in oracle using command line ?

584


How to convert csv to table in oracle?

525


How to add a new column to an existing table in oracle?

588


What does sharding mean?

539


What is a table index in oracle?

632