Can we restore a dropped table after a new table with the same name has been created?

If your database has the RECYCLEBIN option enabled, you can easily restore a dropped table. Try the following command in SQL*Plus:

show recyclebin;

If you have the recyclebin enabled, you will see the dropped tables with their original name and their recyclebin name (starts with BIN$).

You can then query the dropped table with normal SQL (but you may need to quote the name):

SELECT * FROM "BIN$<restofname>"

You can also restore it (and optionally rename it) with:

FLASHBACK TABLE <originalTableName> TO BEFORE DROP;

or

FLASHBACK TABLE <originalTableName> TO BEFORE DROP RENAME TO <newTableName>;

Please refer the answer posted by 'Andrew Mobbs' which is working like gem.

is it working for SQL also? if it is not usefull for sql then tell me the solution for sql