批量删除表或视图

declare
     cursor v_cursor is
       select view_name from user_views where upper(view_name) like 'V/_20%' escape '/' ;
--oracle中_代表一个字符，这里要删所以V_20开头的视图，所以需要转义
begin
for i in v_cursor loop
     execute immediate 'drop view '||i.view_name;
     end loop;
end;

转载于:https://blog.51cto.com/dongdong1314/207984