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 |
How to add Foreign key in a table after the creation of the table?
What is indexing in sql and its types?
What is the difference between the conventional and direct path loader? : aql loader
Is join and inner join the same?
How can you save or place your msg in a table?
why sql is used as interpreter frequently rather than a compile?
What are the types of join and explain each?
What is diff between bulk collect and forall
how to create a database in oracle?please gve anser with example
Types of joins?
What is Histogram?
What is memory optimized?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)