top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is Save Points in Oracle database?

+1 vote
160 views
What is Save Points in Oracle database?
posted May 5, 2014 by Avinash Shukla

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

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, save points are also available in other database e.g. SQL Server

answer May 10, 2014 by Amit Kumar Pandey
Similar Questions
+1 vote

I'm not looking for solution, but steps you would take to figure it out. I don't have experience with APIs and I figured that catching youtube data points and storing them in the database would be a great start?

Here is what I'm trying to accomplish: when I insert youtube video link into a form (create), then: thumb, link, title, date uploaded will get saved into the database as soon as I hit "submit." This will allow me to display these videos using the views.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...