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

Source Code Search

OwnerNameTypeSearch ItemLineTextNName2I1I2
APEXf25384/application/pages/page_01101.sqlEXPORTempno37'on apex 4.2.2 the empno 1 lov gives this type of error:<br/>',1application/pages725
APEXf25384/application/shared_components/logic/application_items/f_empno.sqlEXPORTempno1prompt --application/shared_components/logic/application_items/f_empno1application/shared_components/logic/application_items761
APEXf25384/application/shared_components/logic/application_processes/set_app_item_f_empno_on_lov_selection.sqlEXPORTempno1prompt --application/shared_components/logic/application_processes/set_app_item_f_empno_on_lov_selection1application/shared_components/logic/application_processes765
APEXf25384/application/shared_components/user_interface/lovs/emp_lov.sqlEXPORTempno18'select ename || '' ('' || trim(empno) || '')'' as d',1application/shared_components/user_interface/lovs757
APEXf25384/install.sqlEXPORTempno8@@application/shared_components/logic/application_processes/set_app_item_f_empno_on_lov_selection.sql1install.sql77
APEX_PUBLIC_USERZZZ_001PACKAGEempno4 ( empno emp.empno%type1ZZZ_00100
APEX_PUBLIC_USERTED_P1079PACKAGE BODYmaterialized75 and dpy.type in ('synonym', 'view', 'table', 'package', 'package body', 'function', 'procedure', 'materialized view')1TED_P107900
APEX_PUBLIC_USERTED_PAGE_SUMMARYPACKAGE BODYmaterialized1763 if p_type not in ('table','view','materialized_view','index','sequence') then 1TED_PAGE_SUMMARY00
APEX_PUBLIC_USERZZZ_001PACKAGE BODYempno7 select e.empno1ZZZ_00100
APEX_PUBLIC_USEREMP_TRG1TRIGGERempno5 if :new.empno is null then1EMP_TRG100

Code

Page

Name
Page ID
Name

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source
User Interface
Template

Package

Package
Name
Source

Package Body

Package Body
Name
Source