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

不小心误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%';