利用Connect By构造数列

select rownum from dual connect by rownum <= 12

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

posted @ 2020-05-30 09:52  游兮游兮  阅读(128)  评论(0编辑  收藏  举报