Oracle数据回溯

查询该表指定时间内修改前的记录：

select * from GUPOLICYCOPYMAIN AS OF TIMESTAMP TO_TIMESTAMP('2019-12-29 17:00:00','yyyy-mm-dd hh24:mi:ss');

查询该表近段时间修改的记录：
SELECT GUPOLICYCOPYMAIN.Inputdate
       VERSIONS_STARTTIME,
       VERSIONS_ENDTIME,
       VERSIONS_OPERATION
  FROM GUPOLICYCOPYMAIN VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE
 WHERE VERSIONS_STARTTIME IS NOT NULL
 ORDER BY VERSIONS_STARTTIME DESC;