包含某个注释?
select text from all_source where type='PROCEDDURE' and name='过程名'
and instr(text,'注释内容')>0