What are the usage of SAVEPOINTS?
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
SAVEPOINT statement.
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 / kotravel. b
To perform line by line transaction we r using save point
Is This Answer Correct ? | 4 Yes | 5 No |
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How to move files from one directory to another in pl sql?
How to test for null values?
How to call DDL statements from pl/sql?
how to shut down the server with 'mysqladmin'? : Sql dba
I need a function for a train ticket reservation please answer it thanks in advance
Do prepared statements prevent sql injection?
What found sql?
What is cursor in pl sql?
Which is the best place to learn hadoop?
What is crud stand for?
write a query that returns first characters of each word in Oracel/Sql pl sql