Oracle日期高手請進!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

SQL> select count(*) from
  2  (select
  3      to_date('2004-11-10','yyyy-mm-dd')-1+rownum date1
  4   from
  5      dba_objects
  6   where
  7      to_date('2004-11-10','yyyy-mm-dd')-1+rownum<=to_date('2004-11-24','yyyy
-mm-dd'))
  8  where
  9    to_char(date1,'d') not in (6,7);  COUNT(*)
----------
        11