How to search for a pattern for all files under a given directory and its subdirectory

How to search for a pattern for all files under a given directory and its subdirectory. Examples with in COMMON_TOP we need to find all files that have the word ORACLE_SID in it

find
/appldev/apps/apps_st -name “<ORACLE_SID>”

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.