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 |
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
What exactly do quotation marks around the table name do?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What is data file?
How to run create database statement again?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
25. Display the client number and the value of the highest value order placed by that client.
What is Water Mark in Oracle?
How can I get column names from a table in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What are advantages of dateset in datastage?
What is oracle datasource?