title: List all table origin columns for all views in Oracle database
body: <p>Let's assume I have following tables:</p>
  <pre><code>TABLE_A (ID; NAME; ...)
  TABLE_B (ID; NAME; TABLE_A_FK; ...)
  </code></pre>
  <p>And I expose the table data through this view:</p>
  <pre><code>SELECT a.id, a.name, b.name FROM TABLE_A a
  JOIN TABLE_B b
  ON a.id = b.table_a_fk;
  </code></pre>
  <p>How could i get for my view the information which table and columns are referenced in this view.</p>
  <p>Here I would expect:</p>
  <pre><code>TABLE_NAME  COLUMN_NAME
  -----------------------
  TABLE_A     ID
  TABLE_A     NAME
  TABLE_B     NAME
  TABLE_B     TABLE_A_FK
  </code></pre>
  <p>Currently the only way to solve this is to parse the SQL text inside this statement:</p>
  <pre><code>select view_name, text_vc from sys.all_views;
  </code></pre>
  <p>But isn't funny at all ;).</p>