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 /