DBA Text Search

Description
Categories: Enginatics, Kcapps, Toolkit - DBA
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