oracle通过闪回查询表的更改记录

SELECT empno,
VERSIONS_STARTTIME,
VERSIONS_ENDTIME,
VERSIONS_OPERATION
FROM t1 VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE
WHERE VERSIONS_STARTTIME IS NOT NULL
ORDER BY VERSIONS_STARTTIME DESC;

posted @ 2019-05-30 15:22  Warden_king  阅读(473)  评论(0编辑  收藏  举报