求一段連續日期,但排除六日

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

select allday from (
select to_date('2007-02-15','yyyy-mm-dd')+rownum allday from
(select to_date('2007-02-15','yyyy-mm-dd'),to_date('2007-02-28','yyyy-mm-dd') from dual)
connect by rownum < to_date('2007-02-28','yyyy-mm-dd')-to_date('2007-02-15','yyyy-mm-dd')
) where to_char(allday,'D') >1 and to_char(allday,'D') <7