select * from
(select (to_date('2012-11-1', 'YYYY-MM-DD') + (rownum - 1)) as sdate from dual connect by rownum <= trunc(sysdate) + 1 - to_date('2012-11-1','YYYY-MM-DD')) a
where a.sdate not in ( ‘2013-01-01’ ) ;--列出自2012-11-1至当前时间的每一天 除过2013-01-01
(select (to_date('2012-11-1', 'YYYY-MM-DD') + (rownum - 1)) as sdate from dual connect by rownum <= trunc(sysdate) + 1 - to_date('2012-11-1','YYYY-MM-DD')) a
where a.sdate not in ( ‘2013-01-01’ ) ;--列出自2012-11-1至当前时间的每一天 除过2013-01-01