sql备份数据案例

例子：
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')

oracle复制另外一张表结构到一张新表中

create table newtable as select * from oldtable where 1=2