写个存储过程遍历一遍所有的数据库表的所有字段for i in (select * from user_tables) loop for j in (select * from user_tab_columns where table_name =upper(i.table_name)) execute immediate 'select count(*) from '||i.table_name||' where '||j.column_name||' =aaaa' into v_1; if v_1>0 then insert into t_result() values(i.table_name,j.column,..........);end loop类似这样的sql t_result 表你自己建一下 执行完,看一下t_result 表就知道了
for j in (select * from user_tab_columns where table_name =upper(i.table_name))
execute immediate 'select count(*) from '||i.table_name||' where '||j.column_name||' =aaaa' into v_1;
if v_1>0 then
insert into t_result() values(i.table_name,j.column,..........);end loop类似这样的sql
t_result 表你自己建一下
执行完,看一下t_result 表就知道了
楼主的aaaa是字段的值,不是字段名!
sorry I am wrong!