Data Access Question: Download Oracle Data Access PDF
Explain What is SAVE POINT?
Answer:
For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.
| Previous Question | Next Question |
| Explain What is Execution Plan? | Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command? |