- 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
- --该片段来自于http://www.codesnippet.cn/detail/111120137056.html
来源: http://www.codesnippet.cn/detail/111120137056.html