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