select all_source oracle code example

Example 1: select all_source oracle

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

Example 2: select all_source oracle

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