년초,월초

SELECT TRUNC(SYSDATE, 'MM') AS MON,   --월초

       TRUNC(SYSDATE, 'YYYY') AS YEAR, --년초

       TRUNC(ADD_MONTHS(SYSDATE, -12),'YYYY') AS BEFORE_YEAR --작년초

FROM DUAL;