title: Get metadata of an Oracle SQL query
body: <p>Is there any way in oracle to get the metadata of a running SQL query? As in if my query is:</p>
  
  <pre><code>SELECT fname,
         lname,
         age,
         salary
  FROM emp_tab ;
  </code></pre>
  
  <p>I want to get the metadata of each column returned in the result set (ie: age = NUMBER, lname = VARCAR2(25) etc; ) which is defined in the DB.</p>