Question : sql developer search all packages for text
Answered by : excited-eagle-403xqfg35gw9
SELECT name, line, text FROM all_source WHERE upper(text) like upper('%<<your_phrase>>%') escape '\'
Source : https://stackoverflow.com/questions/251902/is-there-a-way-to-do-full-text-search-of-all-oracle-packages-and-procedures | Last Update : Tue, 24 Aug 21