sql

oracle误删数据恢复

查询删除的数据

#时间可以精确到秒hh24:mi:ss
select * from table as of timestamp to_timestamp('2024-06-03','yyyy-mm-dd')

把删除的数据重新插入原表

#注意主键不要重复
insert into table (

select * from table as of timestamp to_timestamp('2024-06-03','yyyy-mm-dd')

)