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...
funky... "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"
Forum Rules