Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement