select all source oracle

1select *
2from   all_source
3where  lower(text) like lower('%Some source%');

1SELECT * FROM all_source    -- or user_source or dba_source
2WHERE upper(text) LIKE '%MY TEXT%'
3ORDER BY owner, name, type, line;