create or replace procedure find_expr is
  a number;
  begin
    for rec in (select 'select count(*) from ' || table_name || ' where ' ||
                        column_name || ' like ''%05510%''' col_name
                from user_tab_columns t) loop
EXECUTE IMMEDIATE rec.col_name
  into a;

if a > 0 then
  insert into find_expr_log values (sysdate, substr(rec.col_name, 22, 50));
  commit;
end if;