25 lines
424 B
SQL
25 lines
424 B
SQL
col source_owner for a20
|
|
col source_name for a25
|
|
col source_line head LINE# for 999999
|
|
col source_text for a100
|
|
col source_type noprint
|
|
|
|
break on type skip 1
|
|
|
|
select
|
|
owner source_owner,
|
|
type source_type,
|
|
name source_name,
|
|
line source_line,
|
|
text source_text
|
|
from
|
|
dba_source
|
|
where
|
|
lower(owner) like lower('%&1%')
|
|
and lower(name) like lower('%&2%')
|
|
and lower(text) like lower('%&3%')
|
|
order by
|
|
source_type,
|
|
line
|
|
;
|