Reports2017-11-18T12:27:27+00:00

DBA Text Search

Description
Categories: DBA, Enginatics
Full text search through database source code objects such as packages, procedures, functions, triggers etc.

select
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
Owner
ds.owner=:owner
LOV
Object Type
ds.type=:object_type
LOV
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 Name starts with
ds.name like upper(:object_name)||'%'
Code Text contains
lower(ds.text) like '%'||lower(:search_text)||'%'