Answers were Sorted based on User's Feedback
Answer / bindhu
Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
|Is This Answer Correct ?||19 Yes||4 No|
Answer / tulsi
1)In savepoint we can only rollback to every point the
savepoint is issued but we cant do commit at every savepoint
|Is This Answer Correct ?||16 Yes||4 No|
Answer / rahul
used to recover data
that recently deleted
|Is This Answer Correct ?||0 Yes||0 No|
Answer / kotravel. b
To perform line by line transaction we r using save point
|Is This Answer Correct ?||4 Yes||5 No|
Is natural join and inner join same?
Can I call a procedure inside a function?
how to include numeric values in sql statements? : Sql dba
How many clustered indexes can be created on a table?
how to increment dates by 1 in mysql? : Sql dba
what are pl/sql collections?
Is postgresql a server?
What are the uses of merge?
What are sql commands?
Why do we use procedures?
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
What is string join?