Creating savepoint in database

[afidelino]

Hello sir,

I am a beginner in oracle PL/SQL and i am surfing and solving my problem for a long time and you all helps me a lot but i am here with one question which is different from my previous questions.

I want to know the creating save point in oracle and why it is being used in the PL/SQL and please tell me how to implement and manage it.

Thanks.

[Reegan]

Creating savepoint in database

A SAVEPOINT is a point specified during the transaction and used within the PL/SQL implementation.The save point also allows for a partial rollback.

After updating the values in the table effected in the transaction, If we got any problem during execution and transmission of the transaction then you can rollback the transmission of data from the specified SAVEPOINT.

[opaper]

Now,we will see the example to create the save point within the PL/SQL example.The example is illustrated below which can help you to understand the logic behind the savepoint.

SQL> Create Table ...............

    SQL> savepoint 1           ///save point created 


    SQL> INSERT INTO <table_name> VALUES ();


    SQL> savepoint 2 ;      ///save point created

    Savepoint created.

    
    SQL> rollback to 1;

    Rollback complete.

[MindSpace]

If you want to understand the working of the savepoint then you should understand that the savepoint is closely related to the Rollback in the database.

You can understand the example which is described by the opaper,The table is created first as well as a savepoint also created.The third statement specifies that insert a value in the table and then another savepoint has been created name suggested 2 .

In the last statement,the 1st save point is being called by the statement and the inserted values would be destroyed because the whole statement would be rolled back.

[Modifier]

If you really know more about the savepoint and its working then accrding to me this one would be the best example for you.

This tutorial describes the long chainn of values and then the continued operation is being performed with the savepoint associated with the Rollback statement.

You can this example from this link. Tutorial of Savepoint