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
What happens if you use a wrong connect identifier?
How to retrieve the count of updated rows?
What are the types of partitions in oracle?
How to export your connection information to a file?
How to retrieve values from data fields in record variables?
Explain the use of parfile option in exp command.
What is integrity and what is constraint??Explain with example
How to drop an index in oracle?
What is a package in oracle?
How to use attributes of the implicit cursor in oracle?
How to create tables for odbc connection testing?
what is the difference between functional dependecy and multilevel dependency?
Why we use bulk collect in oracle?
How do I manually uninstall oracle client?
What are the roles of dba?