SELECT to_char(add_months(DATE '1990-01-01', rownum - 1), 'yyyymm') FROM dual CONNECT BY rownum <= (2999 - 1990 + 1) * 12;
还有没有其他方法,求高手们教下。谢谢~~~ 也可以不是用oracle的
SELECT day_id FROM (SELECT to_char(199001+ROWNUM-1) day_id, CASE WHEN MOD(199001+ROWNUM-1,100)>0 AND MOD(199001+ROWNUM-1,100)<13 THEN 1 ELSE 0 END flag FROM dual CONNECT BY ROWNUM<=100911) WHERE flag=1;
FROM dual
CONNECT BY rownum <= (2999 - 1990 + 1) * 12;
也可以不是用oracle的
(SELECT to_char(199001+ROWNUM-1) day_id,
CASE WHEN MOD(199001+ROWNUM-1,100)>0 AND MOD(199001+ROWNUM-1,100)<13 THEN 1 ELSE 0 END flag
FROM dual
CONNECT BY ROWNUM<=100911)
WHERE flag=1;