title: Get data type of field in select statement in ORACLE
body: <p>Can I get data types of each column I selected instead of the values, using a select statement?</p>
  
  <p>FOR EXAMPLE:</p>
  
  <pre><code>SELECT a.name, a.surname, b.ordernum 
  FROM customer a
  JOIN orders b
  ON a.id = b.id
  </code></pre>
  
  <p>and result should be like this</p>
  
  <pre><code>name    | NVARCHAR(100)
  surname | NVARCHAR(100)
  ordernum| INTEGER
  </code></pre>
  
  <p>or it can be in row like this, it isn't important:</p>
  
  <pre><code>name           |   surname     |  ordernum
  NVARCHAR(100)  | NVARCHAR(100) |   INTEGER
  </code></pre>
  
  <p>Thanks</p>