1、
两个日期间的天数:
select floor(sysdate - to_date('20110717','yyyymmdd')) from dual;
复制一个表中的部分数据插入同一个表:
insert into channelinfotab
select day_ + 1, channel,play,charge from channelinfotab
where day_=floor(sysdate + 1- to_date('20110717','yyyymmdd'));