欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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');
相关标签: 数据库 oracle