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;