title: SQL to search objects, including stored procedures, in Oracle
body: <p>I need to write some sql that will allow me to query all objects in our Oracle database.  Unfortunately the tools we are allowed to use don't have this built in.
  Basically, I need to search all tables, procedures, triggers, views, everything.</p>
  
  <p>I know how to search for object names.  But I need to search for the contents of the object.
  i.e. SELECT * FROM DBA_OBJECTS WHERE object_name = '%search string%';</p>
  
  <p>Thanks,
  Glenn</p>