title: Calculate age in Oracle/Toad - using values from two columns
body: <p>I have two Oracle columns (in a VIEW, not a table) - DateOfBirth and MembershipDate. I am trying to create a new column that will show the age of the person on the date that they took up the membership.</p>
  <p><br /><strong>Sample columns:</strong><br /><strong>DateOfBirth:</strong> 01/05/1975<br /><strong>MembershipDate:</strong> 01/09/2015<br /><strong>AgeWhenBecameMemb:</strong> 40</p>
  <p>How do I get the third column to get calculated on the fly, please?</p>
  <p><br />I'm looking to implement it using something like this:</p>
  <blockquote>
  <p>SELECT FLOOR(MONTHS_BETWEEN(DATE '2012-01-01', DATE '2010-10-10')/12) AS AgeWhenBecameMemb from DUAL</p>
  </blockquote>
  <p>Thanks!</p>