oracle saurce code code example

Example: oracle saurce code

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