Monday, October 6, 2014

Get All months in Oracle

select to_char(add_months(trunc(sysdate, 'yyyy'), level - 1), 'MONTH') months FROM DUAL connect by level <= 12;