在Oracle中即时生成编号表

这是一种方法：

  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;