Have you dropped a table by mistake and want to restore it? In some cases you can.
Let’s say you’ve run this statement:
DROP TABLE yourtable;
Now, you want to get the employee table back.
You can run the FLASHBACK statement to do this.
FLASHBACK TABLE yourtable TO BEFORE DROP;
Your table will then be restored and you can run queries on it.