What is Save Points in Oracle database?

Question

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.

Answer 1

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