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 is recycle bin in Oracle?
Explain oracle left join with an example?
What is an oracle user account?
What is open database communication (odbc) in oracle?
What are the attributes of the cursor?
What are the attributes of cursor?
How to load data from external tables to regular tables?
What is index-organized table in Oracle?
How to get a create statement for an existing table?
Point out the difference between user tables and data dictionary?
How data locks are respected in oracle?
What happens if you use a wrong connect identifier?
What is rowid and rownum in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database