INSERT INTO TEMP_BUS_TRAVEL_INFO
( SELECT * FROM BUS_TRAVEL_INFO t where to_Char( start_time,‘YYYYMMDD‘)>=‘20170101‘ AND to_Char( start_time,‘YYYYMMDD‘)<=‘20170601‘)
SELECT COUNT(*) FROM TEMP_BUS_TRAVEL_INFO
日期过滤范围把查询出来的结果直接插入到新表中。然后删除。
INSERT INTO TEMP_BUS_TRAVEL_INFO
( DELETE BUS_TRAVEL_INFO t
where to_Char( start_time,‘YYYYMMDD‘)>=‘20170101‘ AND to_Char( start_time,‘YYYYMMDD‘)<=‘20170601‘)
SELECT COUNT(*) FROM TEMP_BUS_TRAVEL_INFO
原文：http://www.cnblogs.com/Early-Bird/p/7883391.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！