select count(*) from
(
select ROWNUM-1 rnum from all_objects
where rownum <= SYSDATE - to_date('2012-12-08','yyyy-mm-dd')+1
)
where to_char( to_date('2012-12-08','yyyy-mm-dd')+rnum-1, 'D') not in ( '6', '7' )
select count(*) from
(
select ROWNUM-1 rnum from all_objects
where rownum <= SYSDATE - to_date('2012-12-08','yyyy-mm-dd')+1
)
where to_char( to_date('2012-12-08','yyyy-mm-dd')+rnum-1, 'D') not in ( '6', '7' )