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 many anonymous blocks can be defined?
How to use group functions in the select clause using oracle?
what are the database links ?
query to find the maximum no persons with same age(age colomn) from emp table
How to see the table columns used in an index?
What is a sub query and what are the different types of subqueries?
what is the difference between simple view and complex view?
what is the difference between oracle enterprise edition and oracle express edition?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What is a Tablespace?
How to use "for" statements in oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?