아래 sql 응용해보세요...

WITH T1 AS (
SELECT 1000 AS SIZ, TO_DATE('2014/05/01 17:34:39', 'YYYY/MM/DD HH24:MI:SS') AS data_dttm FROM DUAL UNION ALL
SELECT 2000 AS SIZ, TO_DATE('2014/01/01 17:29:39', 'YYYY/MM/DD HH24:MI:SS') AS data_dttm FROM DUAL UNION ALL
SELECT 3000 AS SIZ, TO_DATE('2013/11/01 08:30:39', 'YYYY/MM/DD HH24:MI:SS') AS data_dttm FROM DUAL UNION ALL
SELECT 4000 AS SIZ, TO_DATE('2013/05/11 04:06:58', 'YYYY/MM/DD HH24:MI:SS') AS data_dttm FROM DUAL
)
SELECT SIZ, DATA_DTTM, TO_CHAR(DATA_DTTM, 'D') AS DAYS1, DECODE(TO_CHAR(DATA_DTTM, 'D'), '1','일요일', '2','월요일', '3','화요일', '4','수요일', '5','목요일', '6','금요일', '7','토요일') AS DAYS2 FROM T1
WHERE DATA_DTTM BETWEEN '20131101' AND '20140201'
AND TO_CHAR(DATA_DTTM, 'HH24MI') >= '0830'
AND TO_CHAR(DATA_DTTM, 'HH24MI') <= '1730' ;

감사합니다. 많은 도움이 되었습니다.