DBA Text Search

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Full text search through database source code objects such as packages, procedures, functions, triggers etc.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
ds.owner,
ds.type,
ds.name,
ds.line,
ds.text
from
dba_source ds
where
1=1
order by
ds.name,
ds.line
Parameter Name SQL text Validation
Code Text contains 
lower(ds.text) like '%'||lower(:search_text)||'%'
 Char
Object Name starts with 
ds.name like upper(:object_name)||'%'
 Char
FND Message Text 
ds.text like '%'''||(select fnm.message_name from fnd_new_messages fnm where fnm.message_text=:message_text and rownum=1)||'''%'
 LOV
Object Type 
ds.type=:object_type
 LOV
Schema 
ds.owner=:owner
 LOV
Download
   
Related Blitz Reports
XLA Distribution Links Summary RWB Database Objects used by Report Views DBA DBMS Profiler Data DBA SGA+PGA Memory Configuration DBA AWR Active Session History DBA AWR Settings DBA Segments DBA AWR Blocking Session Summary DBA Tablespace Usage
Blitz Report™

Blitz Report™ provides multiple benefits: