I created this package to search for multiple strings at once, in both PL/SQL sources and Apex applications.
It uses the user_sources and user_views views, as well as the Apex API to get an export of the entire application (split into objects).
A SQL-only version (which is simpler to use and faster, but doesn't search in Apex applications, yet), can be found on my Source Code Search (SQL)
Things to note:
- The search is not case sensitive.
- My first attempt was a real resource hog. An 18c XE database really struggled to give any results without a 500 Internal Server Error on this small VPS. This has been fixed however, it now only takes a few seconds.
- 2022-03-17: I have added a "0=1" to the where clause, because this page was also causing performance issues on my own server - mainly because some webcrawlers access this page way too much. So please remove the "0=1" to get results on your own system...
- Allowing wildcards would be nice, but would require use of regular expressions, which would slow things down quite a bit.