1.创建表hhy_test
create table hhy_test(
vname varchar2(20),age number(3),
memo varchar2(10)
)
2.添加数据
select a.*,a.rowid from hhy_test a;
3.delete掉数据,时间为 2018-03-09 16:17:00
4.查询删除的数据,时间设置在delete数据前几分钟
select * from hhy_test as of timestamp to_timestamp('2018-03-09 16:00:00', 'yyyy-mm-dd hh24:mi:ss');
5.插入刚刚删除的数据到原表
insert into hhy_test select * from hhy_test as of timestamp to_timestamp('2018-03-09 16:00:00', 'yyyy-mm-dd hh24:mi:ss');