DBA Text Search

Description

Categories: Enginatics
Repository: GitHub

Full text search through database source code objects such as packages, procedures, functions, triggers etc.
The search can also be done using regular expressions.
To retrieve incorrect custom code such as a frequent performance issue calling the fnd_concurrent\.wait_for_request\s function with a zero interval time, for example, use parameter 'Multi Line Regex search' with the following value: fnd_concurrent\.wait_for_request\s*\(\s*request_id\s*=>\s*\w+\s*,\s*interval\s*=>\s*0\s*,

SQL 20 lines

select ds.* from (
select
ds.owner,
ds.type,
ds.name,
ds.line,
ds.text,
to_clob(null)||&multi_line_text
null multi_line_text
from
dba_source ds
where
1=1
) ds
where
2=2
order by
ds.name,
ds.type,
ds.line

Parameters 9

Parameter

Type

List of values SQL

Code Text contains

Char

lower(ds.text) like '%'||lower(:search_text)||'%'

Multi Line Regex search

Char

regexp_like(ds.multi_line_text,:multi_line_search,'i')

Multi Line window size

LOV

select
case when x.level2<0 then 'lag' else 'lead' end||'(ds.text,'||abs(x.level2)||') over (partition by ds.owner, ds.type, ds.name order by ds.line)||' multi_line_text
from
(select level-:line_window/2 level2 from dual connect by level<:line_window) x

Object Name starts with

Char

ds.name like upper(:object_name)||'%'

FND Message Text

LOV

ds.text like '%'''||(select fnm.message_name from fnd_new_messages fnm where fnm.message_text=:message_text and rownum=1)||'''%'

Object Type

LOV

ds.type=:object_type

Schema

LOV

ds.owner=:owner

Line Number From

Number

ds.line>=:line_number_from

Line Number To

Number

ds.line<=:line_number_to

Description

SQL 20 lines

Parameters 9

Find out more

Features

Download

FAQ