Question

oracle 通过DUAL表如何显示出当前年份的每个月?

Answer 1

今天一个群里问我的，我的答案是下面的，顺手写上
SELECT to_char(SYSDATE,'yyyy-')||ROWNUM mm FROM dual CONNECT BY ROWNUM<13;
或者：
SELECT to_char(SYSDATE,'yyyy-')||trim(to_char(ROWNUM,'09')) mm FROM dual CONNECT BY ROWNUM<13;

Answer 2

行： select 1 from dual
union
select 2 from dual
...........

列：
select 1,2,3,4,5 .... from dual;

Answer 3

select month from dual;