| Objects - Generate SQL to drop all stored objects for the current user/schema login |
--
-- dropobjects.sql
--
-- Objects - Generate SQL to drop all stored objects for the current user/schema login
--
-- Usage: @dropobjects
--
set heading off
set pagesize 0
spool dropobjects.ddl
select 'drop '||object_type||' '||object_name||';'
from user_objects
where object_type in ('VIEW','PROCEDURE','TRIGGER','PACKAGE','FUNCTION')
order by 1;
spool off
|