top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is SAVE POINT explain ?

+2 votes
63 views
What is SAVE POINT explain ?
posted Feb 11, 2015 by Jayshree

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Save points in Oracle can be used for partial rollbacks. For instance we write few SQL statements and don’t want all of them to be committed. We can insert a save point in between and roll back changes until that save point.

Example:

UPDATE emp_name SET salary = salary + 1000 WHERE employee_id = 100;
        DELETE FROM emp_name WHERE employee_id = 130;
        SAVEPOINT do_insert;
        INSERT INTO emp_name VALUES (emp_id, emp_lastname, emp_salary);

On using rollback:

rollback to do_insert;
answer Feb 12, 2015 by Vrije Mani Upadhyay
Similar Questions
+4 votes

How can I save image in SQL SERVER by VB.NET?

+3 votes

I want to save specific html portion into pdf using asp.net into MS SQL SERVER 2008. I know it will done will itextsharp.dll library file from .NET conversion but tell me through example.

...