SELECT * FROM all_source -- or user_source or dba_source WHERE upper(text) LIKE '%MY TEXT%' ORDER BY owner, name, type, line;
select * from all_source where lower(text) like lower('%Some source%');