> 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.