Oracle12C | 查看数据修改记录

1. 查询指定时间之前的数据记录

SELECT * from [表名] AS OF TIMESTAMP TO_TIMESTAMP('2020-8-6 17:00:00','yyyy-mm-dd hh24:mi:ss');

eg：
SELECT * from NEQ_LOT AS OF TIMESTAMP TO_TIMESTAMP('2020-8-6 17: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;

eg：
SELECT rec, recnum, VERSIONS_STARTTIME,VERSIONS_ENDTIME,VERSIONS_OPERATION  FROM NEQ_LOT_DETAILS VERSIONS 
BETWEEN TIMESTAMP TO_TIMESTAMP('2020-8-5 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_TIMESTAMP('2020-8-13 23:59:59','yyyy-mm-dd hh24:mi:ss') 
WHERE id = 'dc999019-0716-4364-9e0c-52bbe2bba058'
ORDER BY VERSIONS_STARTTIME DESC;

第二种方式数据量大的时候查询会比较慢，所以要把握好时间跨度！