ORACLE:: DROP ALL TABLES IN A SINGLE SHOT
If you are into software development, you may have wanted to drop all tables of an Oracle database schema in a single shot, use the following simple PL/SQL procedure.
for i in (select * from tabs) loop
execute immediate ('drop table ' || i.table_name || ' cascade constraints');
‘tabs’ is actually an in-built view in Oracle.