Recover Deleted Data from Table

1) Show

select * from emp;

2) Delete

delete from emp;

3) Save permanent

commit;

now you will not able to find out the  data

Do following steps to revert back

1) Alter

alter table emp enable row movement

2) Flashback

flashback table emp to timestamp systimestamp - interval '1' hour

select * from emp;