Don's Blog

Title: Oracle Select As Of 闪回恢复
Author: 𝓓𝓸𝓷
Created at: 2024-06-15 19:18:55
Updated at: 2024-07-20 05:15:41
Link: https://www.zhangdong.me/select-asof.html
License: This work is licensed under <a class="license" target="_blank" rel="noopener" href="https://creativecommons.org/licenses/by-nc-sa/4.0">CC BY-NC-SA 4.0 .

Oracle Select As Of 闪回恢复

𝓓𝓸𝓷 Lv6

2024-06-15 19:18:55 2024-06-15 19:18:55 Created 2024-07-20 05:15:41 2024-07-20 05:15:41 Updated

Oracle select as of 闪回恢复数据

1
2
3

select * from test_zby as of timestamp (systimestamp - interval '20' minute);

select * from test_zby as of timestamp sysdate - 20/1440;