首页 > 数据库技术 > 详细

oracle根据条件delete以后,数据的回复

时间:2017-02-23 15:21:20      阅读:249      评论:0      收藏:0      [点我收藏+]

不小心误delete了数据,需要恢复过来

insert into emr203
select sq16.nextval as id, hosp_id, swdfl01, sksxm01, sksxm02, sksxm03, sksxm04, sksxm05, sksxm06, sksxm07, sksxm08, nksxm09, sksxm10, sksxm11, sksxm12, sksxm13, sksxm14, sksxm15, sksxm16, sksxm17, sksxm18, sksxm19, dksxm20, sksxm21, sksxm23, sksxm24, sksxm25, nksxm26, nksxm27, sksxm28, nksxm29, nksxm30, sksxm31, nksxm32, deditt, sksxm33  
from emr203  as of timestamp (systimestamp - interval 30 minute) 
where swdfl01 like EMR22%;
--from emr203  as of timestamp (systimestamp - interval ‘30‘ minute) ,30分钟以前的数据

insert into emr205
select sq16.nextval as id, hosp_id, swdfl01, sblgs01, sblgs02, sblgs03, sblgs04, sblgs05, sblgs06, deditt 
from emr205 as of timestamp (systimestamp - interval 30 minute) 
where swdfl01 like EMR22%;

 

oracle根据条件delete以后,数据的回复

原文:http://www.cnblogs.com/szxiaofei14/p/6433256.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!