百度网站怎么用,网站在线优化检测,学校文化建设网站,哪一个做h5的网站好有时候忘记备份数据#xff0c;把数据清空了#xff0c;或者删除了#xff0c;这时候怎么恢复数据呢#xff0c;使用下面sql即可#xff0c;替换对应的table和column
INSERT INTO table1(column1,column2,column3
) SELECTcolumn1,column2,column3
FROMtable1
AS OF time…有时候忘记备份数据把数据清空了或者删除了这时候怎么恢复数据呢使用下面sql即可替换对应的table和column
INSERT INTO table1(column1,column2,column3
) SELECTcolumn1,column2,column3
FROMtable1
AS OF timestamp ( systimestamp - interval 12 hour ); -- 表示12小时之前的数据更多oracle 闪回查询
---闪回查询SQL select * from emp as of timestamp (systimestamp - interval 2 minute); ---查询emp表2分钟之前的数据SQL select * from emp as of timestamp (systimestamp - interval 120 second); ---查询emp表120秒之前的数据SQL select * from emp as of timestamp (systimestamp - interval 12 hour); ---查询emp表12小时之前的数据SQL select * from emp as of timestamp (systimestamp - interval 12 day); ---查询emp表12天之前的数据SQL select * from emp as of timestamp sysdate-2; ---查询emp表2天之前的数据SQL select * from table_name as of timestamp to_timestamp(2023-05-22 10:00:00,yyyy-mm-dd hh24:mi:ss); ---根据时间查询
