title: Looking for tables/columns that contain specific substring
body: <p>Is there any way to query an entire Oracle database using sql or plsql to return a list of all tables/columns that contain the specific substring? Note that I want to look for the substring within the data (not within the table/column names themselves). </p>
  
  <p>I have an issue where a character looks like a space, but is actually a different character.  I have proven this out by taking the substring text and putting it through a hexadecimal converter.  I need to be able to locate everywhere in the database this character exists, so I can replace it with an actual space. </p>
  
  <p>Any thoughts?</p>