比较oracle日期

select * from dlv_notice where dlv_date >= to_date("20050101","yyyymmdd") and dlv_date <= ("20051111","yyyymmdd");