title: Return data type of expression in Oracle
body: <p>Is there a way to get the data type of an expression in Oracle?</p>
  
  <p>For example, in Teradata I can write </p>
  
  <pre><code>SELECT TYPE(4 + 4); 
  </code></pre>
  
  <p>and get Integer. But the same doesn't work in Oracle</p>
  
  <pre><code>SELECT TYPE(4 + 4)
    FROM dual;
  </code></pre>
  
  <p>Returns an error. I know I can look at the table description, but this way would come in handy if it's possible.</p>