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 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) page.

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.

Source Code Search

Code

Page

Identification
Page ID
Name

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source
Appearance
Template

Package

Package
Name
Source

Package Body

Package Body
Name
Source