WITH t AS ( SELECT TO_DATE('20101230', 'yyyymmdd') sdt , TO_DATE('20110302', 'yyyymmdd') edt FROM dual ) SELECT TO_CHAR(sdt, 'ww') ww , TO_CHAR(sdt, 'w') w , TO_CHAR(sdt, 'iw') iw , TO_CHAR(sdt, 'yyyymmdd') sdt , TO_CHAR(sdt + 6, 'yyyymmdd') edt FROM ( SELECT TRUNC(sdt, 'd') + LEVEL*7 - 7 sdt FROM t CONNECT BY LEVEL <= (TRUNC(edt, 'd') - TRUNC(sdt, 'd'))/7 + 1 ) ;
감사합니다^-^
ㅠㅠ 에고..나름 열심히 한다고는 하는데
오라클...아직 배울게 너무 많네요 ㅠ
감사합니다^^