Oracle数据库批量删除表、视图、序列、存储过程、函数脚本

-- 生成删除oracle数据库表的脚本语句
select 'drop table ' || table_name || ';' as sqlscript from user_tables; --delete tables
-- 带过滤条件删除oracle数据库表的脚本语句
select 'drop table ' || a.table_name || ';    --' || a.comments 
from user_tab_comments a 
where a.table_type in ('TABLE') and table_name like 'test_%';

--删除序列
select 'drop sequence ' || sequence_name || ';' as sqlscript from user_sequences; --delete seqs
--过滤条件删除序列
select 'drop sequence ' || sequence_name || ';' as sqlscript from user_sequences where sequence_name like 'SEQ_TEST_LOG_%';

select 'drop procedure ' || object_name || ';' as sqlscript from user_objects  where object_ty

select 'drop type ' || type_name || ';' as sqlscript from user_types; --delete types

select 'drop view ' || view_name || ';' as sqlscript from user_views;  --delete views

select 'drop function ' || object_name || ';' as sqlscript from user_objects  where object_

select 'drop package ' || object_name|| ';' as sqlscript from user_objects  where object_type = 'PACKAGE