jkit001
asked on
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
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Small correction to the post above:
select * from dba_source where lower(text) like lower('%your string goes here%')
select * from dba_source where lower(text) like lower('%your string goes here%')
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
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
ASKER
This works for me. Thanks.
http://www.quest.com/toad-for-oracle/
you can select what code you want to look in and what schemas you want to look