> Can any one tell me,how to retirve the data which had deleted for an instance ,i mean how to
> rollback the previous.
To get the functionality of a rollback you next to begin with a transaction:
begin transaction;
delete from foo;
--oops I deleted to much;
rollback;
Regards,
Richard Broersma Jr.