Delete all table in the schema with a single command

[sonuji_in]

Thanks for the co-operation and instant reply....

This procedure worked fine and I was able to delete all the tables :

spool drop.sql
select 'drop table ' || table_name || ';' from tabs;
spool off

@drop


but, I want to delete all tbe objects in the schema.

Thanks,,