DBA Text Search

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Full text search through database source code objects such as packages, procedures, functions, triggers etc.
Run DBA Text Search and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Blocking Session Summary DBA Segments DBA AWR Settings DBA Tablespace Usage
Blitz Report™

Blitz Report™ provides multiple benefits: