I need to search for the some text on all packages/procedures/functions in the database. How do I do this? Thanks.
I have the sql - thanks.
select name, line,type, text from dba_source
where text like '%text....%'
i think u can limit the condition as u may not be wanting to see the code in SYS and SYSTEM schemas...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"