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.
- Allowing wildcards would be nice, but would require use of regular expressions, which would slow things down quite a bit.