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

posted on   pokeTwo  阅读(154)  评论(0编辑  收藏  举报

努力加载评论中...
点击右上角即可分享
微信分享提示