SQL篇——根据出生日期计算人的年龄

 

trunc((to_char(sysdate, 'yyyyMMdd') - to_char(a.birth_date, 'yyyyMMdd')) / 10000) as age;