oracle全库查找是否有某个值
时间：2021-07-01 10:21:17
帮助过：5人阅读
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 ‘‘%要找的值%‘‘ ‘;
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;
oracle全库查找是否有某个值
标签：except exec pre where int table count ble code
