title: Search PL/SQL Code
body: <p>SELECT * from ALL_OBJECTS returns the names of various procedures/packages/tables/other db objects. I want to look inside the PL/SQL code for a matching string.  How do I do this?</p>
  
  <p>Something like: (pseudocode)  SELECT * FROM all_code WHERE line_of_code like '%mytext%'</p>