List of PL/SQL Code Blocks that Contain a Specified Word.

Join this site Explore »

Oracle Database » SQL Library » List of PL/SQL Code Blocks that Contain a Specified Word.

--
-- 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
/