I need help .... the most urgent possible.
declare
msg varchar2(5000);
resp varchar2(1000);
begin
for c in ( select distinct table_name,column_name
from all_cons_columns
where table_name like 'DIM%'
and constraint_name like '%FK'
and owner = 'MDW'
order by table_name) loop
msg := 'SELECT COUNT(*) FROM ' || c.table_name || ' WHERE ' || c.column_name || '= -1;';
EXECUTE IMMEDIATE msg into resp;
-- execute immediate 'SELECT COUNT(1) FROM ' || c.table_name || ';'
--into msg;
dbms_output.put_line (msg);
end loop;
end;