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;