a guest Jul 22nd, 2019 78 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. begin
  2.   for c_links in (select '@'||db_link as db_link from ALL_DB_LINKS)
  3.   loop
  4.     dbms_output.put_line('search for link: '||c_links.db_link);
  5.     for c_source in (select * from all_source s
  6.                       where s.text like '%'||c_links.db_link||'%')
  7.     loop
  8.       dbms_output.put_line('link '||c_links.db_link || 'is used in: ' ||;
  9.     end loop;
  10.   end loop;
  11. end;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand