오라클 주중 날짜만 구하기

출처 - http://www.okjsp.pe.kr/seq/100156

SELECT SUM(DECODE(YO,1,0,7,0,1)) RESULT FROM ( SELECT TO_CHAR(SYSDATE+(LEVEL-3655),’YYYYMMDD’) DATES,TO_CHAR(SYSDATE+(LEVEL-3655),’D’) YO FROM DUAL CONNECT BY LEVEL-365*5< 365 * 5 + 1 ) WHERE DATES BETWEEN ‘20070715’ AND ‘20070731’