What is SAVE POINT ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suresh somayajula
it is nopthing but , sub divide the transaction into
smaller part.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / abitha
SAVEPOINT usually applies to an individual transaction; it
marks a point to which the transaction can be rolled back,
so subsequent changes can be undone if necessary.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / padmaja
this is used to save a query/transaction at a particular point
by using save<file name>
| Is This Answer Correct ? | 3 Yes | 2 No |
SAVEPOINT is used to locate the transaction for further
manipulations.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is raw datatype in oracle?
What is the difference between SQL and SQL Server?
What is the difference between substr & instr functions?
What is varray?
Explain an index?
What is an external table?
How will you write a query to get a 5th rank student from a table student_report?
How to drop an index in oracle?
how to genarate random numbers in oracle for particular row?
Explain what are clusters?
What is clustered table in Oracle?
What is SQL access advisor in Oracle?