17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT TO_DATE('200810', 'YYYYMM') + ROWNUM - 1
FROM DUAL
CONNECT BY ROWNUM <= TO_CHAR(LAST_DAY(TO_DATE('200810', 'YYYYMM')), 'DD')
select t.id, t1.d, t.xx
from t,
(select to_date('20080101', 'yyyymmdd') + rownum - 1 d
from all_objects
where rownum <= to_char(to_date('20081231', 'yyyymmdd'), 'ddd')) t1
where t1.d = trunc(t.dd(+), 'dd')