Search through code in all triggers & store procedures: Oracle?

I am using Oracle 9 and10.  We have hundreds of store procedures and triggers.  Is there a way to search through all of the code?  I would hate to open each one just to look for a string.

Thanks
jkit001Asked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
select * from dba_source where text like '%your string goes here%'
0
 
Geert GOracle dbaCommented:
yes: Toad
http://www.quest.com/toad-for-oracle/

you can select what code you want to look in and what schemas you want to look
0
 
slightwv (䄆 Netminder) Commented:
Small correction to the post above:

select * from dba_source where lower(text) like lower('%your string goes here%')
0
 
sdstuberCommented:
no need to correct anything.

if you want an exact string search do not use LOWER

if you do not want an exact string search, then you can


also note, if you don't have access to dba_source, you could try all_source instead.
but, despite the name "all", you might miss some objects
0
 
jkit001Author Commented:
This works for me.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.