Oracle查看表历史记录

1.查询某张表某时间之前的记录，时间后可添加where条件
select * from  表名 AS OF TIMESTAMP TO_TIMESTAMP('2020-09-21 13:00:00','yyyy-mm-dd hh24:mi:ss')

2.查询某表近段时间修改记录
SELECT 字段名 VERSIONS_STARTTIME, VERSIONS_ENDTIME, VERSIONS_OPERATION

FROM 表名  VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE
WHERE VERSIONS_STARTTIME IS NOT NULL
ORDER BY VERSIONS_STARTTIME DESC;