title: Find a certain column name in all views in one select statement
body: <p>I'm searching for a certain column name in all views. I know that the following works for all tables but don't know how to do it for all views:</p>
  
  <p>What I use to find a column_name='SHORT_TITLE' in all tables but now need to search all views:</p>
  
  <p>SELECT table_name, column_name FROM all_tab_columns WHERE column_name='SHORT_TITLE'</p>
  
  <p>Thanks</p>