select 'drop '|| o.OBJECT_TYPE||' ' ||o.OBJECT_NAME from user_objects o;
删除用户下面的所有对象
于 2018-08-21 14:38:38 首次发布
select 'drop '|| o.OBJECT_TYPE||' ' ||o.OBJECT_NAME from user_objects o;