SQL- search a db object for a string

select * from ALL_SOURCE where text like '%some string%';