title: PL/SQL: How can I calculate the AGE knowing a column called Birth_Date?
body: <p>I have a table consisting of one column <code>(BIRTH_DATE)</code>. How could I use sysdate to subtract from all the rows of my <code>BIRTH_DATE</code> and <code>GROUP BY</code> them together?</p>
  
  <p>to be more clear: </p>
  
  <p>Here is what I have fetched, now I would like to add an AGE Column to the below Table for all rows</p>
  
  <pre><code>ID     Birth_Date
  ___    ___________
  1       02-JAN-63
  2       23-OCT-31
  3       30-DEC-35
  4       06-MAY-83
  </code></pre>
  
  <p>Thanks in advance!</p>