Organizational Research By

Surprising Reserch Topic

boostr.in questions - Question:What is Save Points in Oracle database?


 

 SAVE POINTS are used to divide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed. Whenever we encounter error we can rollback from the point where we set our SAVEPOINT.This is useful for multistage transaction and conditional transaction where commit and rollback depend on certain condition. This is another commonly asked Oracle Interview Question and since save points are also available in other database e.g. SQL Server, some time Interviewer follow up with differences with other database as well.
asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes
8 views



Related Hot Questions



Government Jobs Opening


...