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 |
How to convert dates to characters in oracle?
What are main difference between Stored Procedure and Functions.
What is where clause in oracle?
What is dual table oracle?
What is Undo Management Advisor in Oracle?
Why does oracle 9i treat an empty string as null?
definition of cluster and non-clustered index?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
am completed mca2011 how get certification in oracle
What is Index and different types of Indexes?
Is oracle a programming language?
What is logical backup in oracle?