Delete all table in the schema with a single command

[pando]

set termout on
set head off feedback off verify off termout off
spool /tmp/drop_all.sql
Select 
Rtrim('drop '||object_type||' '||owner||'.'
       ||object_name||decode(object_type,'TABLE',' cascade constraints')
       || ';' )
from dba_objects
where owner = upper('&owner')
order by object_name
/
spool off

set head on feedback on verify on

spool /tmp/drop_all.log

set echo on
@/tmp/drop_all.sql
spool off

set echo off

set pagesize 14 termout on