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 are the factors causing the reparsing of SQL statements in SGA?
"primary key=unique+null" is equal,reson?not,reason?
What are the oracle built-in data types?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Can a Tablespace hold objects from different Schemes ?
Define the terms primary key foreign key and also the difference between primary and the unique key
Is truncate autocommit in oracle?
What is an oracle database table?
How to add another datafile to a tablespace?
what is the syntax of SELECT command?
What is the function of Optimizer ?
What is a package ? What are the advantages of package ?