Thread: Retrieve after roll back

I have a doubt...

Here goes

If i add a row to a table, and wont use the command commit.
When i delete that particular row, and use roll back will i be able to retrive it?

Actually I need explanation abt working of roll backk?

Your question is really intresting.

But you will not be able to retrive that record.
Actually tilll u commit the transactions are stored in memory not in actual database table. when u delete it is deleted from there.
So no chance of tetriving it back.

u will not get datas because u have not use commit for insert rows so u have used rollback that time full session rollback or after commit.
so hence use savepoint.

hello prakash,

without commiting, the inserted row is not saved in the database,just it is stored in the memory.
here is the example.

SAVEPOINT S1;
UPDATE STMT..
create STMT.
SAVEPOINT S2;
INSERT
ROLLBACK TO S1;

For the above sequence first one savepoint is created s1. next update is done.next create stmt(ddl stmt)
another savepoint s2 is created.
after this insert the row.

1)when we r giving rollback to s1.
upto the savepoint s1 it will roll back.
creating the save point means,just we r giving conformation of transactions(dml stmts) which r done before savepoint.

2) another is we have done some set of transactions(dml stmts), after this if we give any ddl command(create alter drop)
our transactions before this ddl stmts are automatically get commited.