利用Connect By构造数列

select rownum from dual connect by rownum <= 12

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