Oracle 恢復表中誤刪的數據

 

查詢20分鐘前的資料
SELECT * FROM TableName AS OF TIMESTAMP SYSDATE - 20/1440;
查詢指定時間前的資料
SELECT * FROM TableName AS OF TIMESTAMP TO_TIMESTAMP('2020-01-01 12:10:10','YYYY-MM-DD HH24:MI:SS');

查到後就可以把該紀錄插入表中
INSERT INTO TableName   
      SELECT * FROM TableName AS OF TIMESTAMP SYSDATE - 20/1440 WHERE ID = '123'
COMMIT;

ps.1440代表一天有1440分鐘

By Hao★