大家好,除了下面这种方法,还有更好的列出所有月份的方式吗:
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 <= 1
还有一个问题请看下面
另外,我想列出包括当前年份在内的前两年。我编写了以下SQL查询语句,请告诉我是否有更好的方法。
select extract(year from sysdate) - (level-1) as years
from dual
connect by level <=3
order by years