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