利用Connect By构造数列

1 select rownum from dual connect by rownum <= 12

1 SELECT '2016/'||substr('0'||to_char(rownum),-2,2) yymm 
2   FROM DUAL CONNECT BY rownum<=12;

 

 

posted @ 2017-01-10 16:22  游兮不归  阅读(190)  评论(0编辑  收藏  举报