select '01' as month from dualunion
select '02' as month from dualunion
select '03' as month from dual
union
select '04' as month from dual
union
select '05' as month from dual
就列出 01,02,03,04.12有什么简便方法写出吗
select '02' as month from dualunion
select '03' as month from dual
union
select '04' as month from dual
union
select '05' as month from dual
就列出 01,02,03,04.12有什么简便方法写出吗
connect by rownum<=12
connect by rownum <=12
select * from month01
union
select * from month02
union
.
.
.
.
union
select * from month12呢
有没有快捷方法