Sql Developer Search All Packages For Text

[Solved] Sql Developer Search All Packages For Text | Sql - Code Explorer | yomemimo.com
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

Answers related to sql developer search all packages for text

Code Explorer Popular Question For Sql