title: Oracle: select * from (select table_name from ... )?
body: <p>Given a query that returns the name of tables, is it possible to evaluate the name and use it in a subsequent query?</p>
  
  <p>E.G.</p>
  
  <pre><code>select count(1) from x where x in 
      (select table_name from ALL_TABLES where table_name like 'MY_TABLE_%');
  </code></pre>
  
  <p>Obviously this is invalid syntax, but it should illustrate what I'm trying to do.</p>