oracle结构一年的12个月

oracle构造一年的12个月

最近项目中遇到，记录下来

?

方法可以是：

?

?

select '1' month from dual union all
select '2' month from dual union all
select '3' month from dual union all
select '4' month from dual union all
select '5' month from dual union all
select '6' month from dual union all
select '7' month from dual union all
select '8' month from dual union all
select '9' month from dual union all
select '10' month from dual union all
select '11' month from dual union all
select '12' month from dual;

?或者

?

?

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

?

?

查看更多 下一篇