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;
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)