Oracle查询表某时间之前的记录及回滚

查询表格某时间之前的记录

SELECT * FROM PRD_TEST AS OF TIMESTAMP TO_TIMESTAMP('20230331 17:41:00','YYYYMMDD HH24:MI:SS') ORDER BY id desc;

开启回滚权限

alter table PRD_TEST enable row movement;

回滚表数据至某时间之前

flashback table PRD_TEST to timestamp to_timestamp('20230331 17:41:00','YYYYMMDD HH24:MI:SS');