1,view_name like‘V/_1/_%’
2,该视图记录数大于2
本来在bbs上发贴问的,没有后文。晚上外出回来写写居然出来了。
declare
     v_sql varchar2(200);
     v_count number;
     cursor v_cursor is
                    select view_name from user_views
                    where view_name like 'V/_1/_%' escape '/';
begin
     for i in v_cursor loop
             v_sql:='select count(*) from '||i.view_name;
             execute immediate v_sql into v_count;
             --dbms_output.put_line(v_count);
             if v_count>2 then
                    dbms_output.put_line(i.view_name);
             end if;
     end loop;
end;

不知还有没更简单的方法,恳请指教~