Interested to Buy Any Domain ? << Click Here >> for more details...
What is SAVE POINT ?
- 5 Answers
- 9438 Views
- I also Faced
- E-Mail Answers
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 kernel?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What are the different types of databases?
How to estimate disk space needed for an export job?
what is view?
query optmization techniques and quwry analyser+projects+ppts
Can the default values be assigned to actual parameters?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
How to create a new table by selecting rows from another table?
How to define an oracle sub procedure?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is difference between truncate and delete?
Oracle General 
