oracle 怎么求出一年的12个月

来源：百度知道 编辑：UC知道 时间：2024/06/05 21:38:39
问题很简单，我要用一条sql求出一年的12个月份
结果写在一个字段下
例：month
01
02
.
.
11
12

select XXX from dual

在线等

select lpad(level,2,0) from dual
connect by level<13

不知道你的目的是什么。但想出现这个结果可以用union all

select '01' month from dual union all
select '02' month from dual union all
select '03' month from dual union all
select '04' month from dual union all
select '05' month from dual union all
select '06' month from dual union all
select '07' month from dual union all
select '08' month from dual union all
select '09' month from dual union all
select '10' month from dual union all
select '11' month from dual union all
select '12' month from dual;

MARK!@