我该如何在Oracle中获取最近10年的列表?
这是我的尝试:
SELECT TO_CHAR(SYSDATE,'yyyy') FROM DUAL
UNION ALL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-12),'yyyy') FROM DUAL
UNION ALL
SELECT to_char(add_months(sysdate,-24),'yyyy') FROM DUAL
UNION ALL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-36),'yyyy') FROM DUAL
UNION ALL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-48),'yyyy') FROM DUAL
UNION ALL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-60),'yyyy') FROM DUAL
UNION ALL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-72),'yyyy') FROM DUAL
UNION ALL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-84),'yyyy') FROM DUAL