Advanced Search

Return to Snippet

Revision: 56614
at April 5, 2012 14:12 by jstrawther
Updated Code 
Oracle:

SELECT 
  type, 
  name, 
  line	
FROM   
  user_source -- or dba_source, or all_source
WHERE
  UPPER(text) LIKE UPPER('%keyword%');


SQL Server:

SELECT 
  object_name(id)
FROM 
  syscomments
WHERE  
   UPPER(text) LIKE UPPER('%keyword%');

Revision: 56613
at April 5, 2012 03:58 by jstrawther
Initial Code 
Oracle:

SELECT 
  type, 
  name, 
  line	
FROM   
  user_source -- or dba_source, or all_source
WHERE
  UPPER(text) LIKE UPPER('%slbtransinsured%');


SQL Server:

SELECT 
object_name(id)
FROM 
syscomments
WHERE  
text like ‘%search string%’
Initial URL 









Initial Description





Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.









Initial Title





Search DDL (stored procedures, functions, etc) for keywords









Initial Tags





sql, search, server, Oracle









Initial Language





SQL