select trunc(months_between(日期,日期)/12) from dual
select trunc(months_between(SYSDATE ,TO_DATE('19961110','yyyyMMdd'))/12) from dual
select trunc(months_between(日期,日期)/12) from dual
select trunc(months_between(SYSDATE ,TO_DATE('19961110','yyyyMMdd'))/12) from dual