title: Return Oracle column names in table.column format?
body: <p>Is there any setting or method I can use to get Oracle to return results in <code>&lt;table&gt;.&lt;column&gt;</code> format?  For example:</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT     *
  FROM       foo f
  INNER JOIN bar b
  ON         b.foo_id = f.id
  </code></pre>
  
  <p>Desired results:</p>
  
  <pre><code>F.ID  F.BLAH  B.ID  B.FOO_ID  B.BLAH
  --------------------------------------------------------
  1     blah    7     1         blah
  2     blah    8     2         blah
  3     blah    9     2         blah
  </code></pre>
  
  <p>The obvious solution is to individually alias each column <code>SELECT f.id AS F_ID, ...</code>; however, I'm needing to export some very large legacy tables (300+ columns), so using this method would cause the queries to be enormous and impractical.</p>