title: Find all join referenced tables in SQL
body: <p>I need to extract from V$SQL all the objects (tables or views) that are referenced in all the joins of the sql.
  For example: if i have this sql in the V$SQL</p>
  <pre><code>select * from ADANPT 
  join BTABP on column1=column2 
  left outer join HSTUDI on column3=column4
  full outer join TERW on column5=column6;
  </code></pre>
  <p>i need to extract this:</p>
  <pre><code>BTABP
  HSTUDI
  TERW
  </code></pre>
  <p>I i have just one join in my sql, it is quite simple, using <code>substr</code> and <code>instr</code> functions (so that i extract the string from JOIN to ON words).
  But i can't find a way if i have 2 or more joins. Maybe with loop?</p>