oracle删除某个用户下的对象

删除某个用户下的对象,实际上就是拼装查询几张系统表，将结果拷出来执行一下。

--Drop constraint  
select 'alter table ' || table_name || ' drop constraint ' ||  constraint_name || ' ;'  from user_constraints where constraint_type = 'R';  

--Drop tables  
select 'drop table ' || table_name || ';' from user_tables;

--Drop view  
select 'drop view ' || view_name || ';' from user_views;  

--Drop procedure  
select 'drop procedure ' || object_name || ';'  from user_procedures where object_type = 'PROCEDURE';  

--Drop function  
select 'drop function ' || object_name || ';' from user_procedures where object_type = 'FUNCTION';  

--Drop sequence  
select 'drop sequence ' || sequence_name || ';' from user_sequences;