Oracle根据生日计算年龄以及分类所属年龄段sql片段

根据生日字段计算年龄sql片段：

(extract(year from sysdate)-extract(year from b.insbirthday)） age,  

根据年龄分类所属年龄段sql片段：

--年龄所属阶段(0：40岁以下，1：40-49，2:50-59，3:60-69，4:70-79，5:80以上)
case WHEN (extract(year from sysdate)-extract(year from b.insbirthday)）>=0 and (extract(year from sysdate)-extract(year from b.insbirthday)）<40 THEN '0'
WHEN (extract(year from sysdate)-extract(year from b.insbirthday)）>=40 and (extract(year from sysdate)-extract(year from b.insbirthday)）<50 THEN '1'
WHEN (extract(year from sysdate)-extract(year from b.insbirthday)）>=50 and (extract(year from sysdate)-extract(year from b.insbirthday)）<60 THEN '2'
WHEN (extract(year from sysdate)-extract(year from b.insbirthday)）>=60 and (extract(year from sysdate)-extract(year from b.insbirthday)）<70 THEN '3'
WHEN (extract(year from sysdate)-extract(year from b.insbirthday)）>=70 and (extract(year from sysdate)-extract(year from b.insbirthday)）<80 THEN '4'
WHEN (extract(year from sysdate)-extract(year from b.insbirthday)）>=80 THEN '5'
ELSE '年龄有误' END ageflag,