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