oracle中commit之后回滚
程序员文章站
2022-07-04 22:12:11
...
//先查询到需要恢复的记录
select * from table1
as of timestamp to_timestamp('2020-5-14 15:36:10','yyyy-mm-dd hh24:mi:ss');
delete from table1
//删除所有数据后重新插入
insert into table1
select * from table1
as of timestamp to_timestamp('2020-5-14 15:36:10','yyyy-mm-dd hh24:mi:ss');
下一篇: 哲学家问题