현재일 기준으로 이번주 날짜 뽑는 쿼리

출처 :  http://cafe.naver.com/prodba.cafe



select sysdate from dual;

Sysdate
04/16/2010 11:24:38



select to_char(sysdate - 7 + level + (select next_day(sysdate,1) - sysdate from dual),'yyyymmdd') as dt
from dual
connect by level <= 7;

20100412
20100413
20100414
20100415
20100416
20100417
20100418



select to_char(sysdate - to_number(to_char(sysdate,'d')) + level,'yyyymmdd') as dt
from dual
connect by level <= 7;


20100411
20100412
20100413
20100414
20100415
20100416
20100417