I need to search for the some text on all packages/procedures/functions in the database. How do I do this? Thanks.
Printable View
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... :)