--

-- List of all code-objects that contain the specified word.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

COLUMN name FORMAT A30

COLUMN line FORMAT 9999

COLUMN text FORMAT A110

BREAK ON Name Skip 2

SELECT a.name "Name",

       a.line "Line",

       Substr(a.text,1,200) "Text"

FROM   all_source a

WHERE  Instr(Upper(a.text),Upper('&&Search_Term')) != 0

AND    a.owner = Upper('&&Owner')

ORDER BY 1,2

/