title: Oracle search text of views
body: <p>I have over 1000 views and I want to run a search which will display the names of the views containing the string <code>abc</code> in its SQL. How do I search all stored procedures/SQL including that of my views? When I run the command: </p>
  
  <pre><code>SELECT *
  FROM   all_source
  WHERE  text LIKE '%abc%'
  </code></pre>
  
  <p>it returns me source code in which the string <code>abc</code> is present. But this does not include views.  </p>