title: Get list of tables used in a complex query
body: <p>Suppose there is an oracle query which calls an function</p>
  
  <pre><code>select * from table(xyz(to_date('10/04/2017', 'dd/mm/yyyy')))
  </code></pre>
  
  <p>and function xyz has two select statements in it</p>
  
  <pre><code> select * from A
  </code></pre>
  
  <p>and</p>
  
  <pre><code>select * from B
  </code></pre>
  
  <p>So this query references(reads/writes/updates) two tables <code>A</code> and <code>B</code></p>
  
  <p>Is there a way to know the number of tables that are  referenced when I run this query on oracle ?</p>