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 an Index Segment ?
What is archive log in Oracle?
How many anonymous blocks can be defined?
What is proxy method?
Which Oracle App Is Most Popular One ?
What are the components of logical database structure in oracle database?
Can we create database in oracle using command line ?
Are truncate and delete commands same? If so why?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
what is the use of composite key constraint?
13. Display the second to fifth characters in each client name.
what is Table ?