List all the months using oracle sql .
Posted
by
Suresh S
on Stack Overflow
See other posts from Stack Overflow
or by Suresh S
Published on 2011-01-03T07:58:13Z
Indexed on
2011/01/03
8:53 UTC
Read the original article
Hit count: 232
Guys is there any better way to list all the months other than this
select to_char(add_months(to_date('01/01/1000', 'DD/MM/RRRR'), ind.l-1),
'MONTH') as
month_descr
, ind.l as month_ind
from dual descr
, (
select l
from (select level l from dual connect by level <=
12)
) ind
order by 2;
ANSWER :
SELECT to_char(add_months(SYSDATE, (LEVEL-1 )),'MONTH') as months FROM dual CONNECT BY LEVEL <= 12
© Stack Overflow or respective owner