Skip to Main Content

Info

I created this package to search for multiple strings at once, in both PL/SQL sources and Apex applications.
It uses both the user_sources view and the Apex API to get an export of the entire application (split into objects).

Things to note:
  • The search items are case sensitive.
  • Searching in Apex applications is a real resource hog. An 18c XE database really struggles - it even gives a 500 Internal Server Error on this small VPS - so this is best reserved for bigger servers.
  • Allowing wildcards would be nice, but would require use of regular expressions, which would slow things down even further.
  • I also tried a version using apex_split, to split the export objects into lines, but that was way too slow.
  • The use of 2 pipelined table functions may look a bit strange, but it seemed like the fastest way to make sure it only returns the most relevant results.

Code

Page

Name
Page ID
Name

Package

Package
Name
Source

Package Body

Package Body
Name
Source