这是一种方法:
SELECT yr
FROM ( SELECT EXTRACT (YEAR FROM (ADD_MONTHS ( SYSDATE, - ( (LEVEL - 1) * 12)))) yr
FROM DUAL
CONNECT BY LEVEL <= 4)
ORDER BY yr;
或者:
SELECT yr
FROM ( SELECT EXTRACT (YEAR FROM sysdate) - (level -1 ) yr
FROM DUAL
CONNECT BY LEVEL <= 4)
ORDER BY yr;
或者:
SELECT yr
FROM (SELECT EXTRACT (YEAR FROM SYSDATE) - (x - 1) yr
FROM DUAL
MODEL
DIMENSION BY (1 AS z)
MEASURES (1 x)
RULES
ITERATE (4)
(x [ITERATION_NUMBER] = ITERATION_NUMBER + 1))
ORDER BY yr;