select *
from t as of timestamp sysdate-1/(24*60)*N
where ...;
-- 查询t表N分钟前的状态
Oracle 闪回查询简录
最新推荐文章于 2023-03-08 17:10:59 发布
select *
from t as of timestamp sysdate-1/(24*60)*N
where ...;
-- 查询t表N分钟前的状态