怎么在某Schame下搜索数据
怎么在某Schame下搜索数据:
比如:在scott下面,搜索含有Adan的数据的表和字段
[解决办法]
最笨的当然是穷举法了：

declare
  v_Sql   varchar2(2000);
  v_count number;
begin
  for xx in (select t.OWNER, t.TABLE_NAME, t.COLUMN_NAME
               from dba_tab_columns t
              where t.OWNER = 'SCOTT') loop
    begin
      v_Sql := 'select count(1) from ' 
[解决办法]
 xx.owner 
[解决办法]
 '.' 
[解决办法]
 xx.table_name 
[解决办法]

               ' where ' 
[解决办法]
 xx.column_name 
[解决办法]
 ' like ''%Adan%'' ';
      execute immediate v_Sql
        into v_count;
      if (v_count >= 1) then
        dbms_output.put_line(xx.table_name 
[解决办法]
 ':' 
[解决办法]
 xx.column_name);
      end if;
    exception
      when others then
        null;
    end;
  end loop;
end;