알아두면 쓸모있는 쿼리

SELECT TO_NUMBER(TO_CHAR(SYSDATE,'YYYY')) - LEVEL + 1 YEAR FROM DUAL CONNECT BY LEVEL <= (TO_NUMBER(TO_CHAR(SYSDATE,'YYYY')) - 2010); SELECT LPAD(ROWNUM,2,'0') MON FROM DUAL CONNECT BY LEVEL <= 12;