How to find a particular text in the database?

Ex: If you want to find all the places where a particular function is used,

More info on sys_comments