oracle如何查询记录生成时间戳,Oracle使用范围内的时间戳记记录历史记录

小编典典

是的，像这样：

SQL> select sal from emp where empno=7369;

SAL

----------

5800

SQL> update emp set sal = sal+100 where empno=7369;

1 row updated.

SQL> commit;

Commit complete.

SQL> update emp set sal = sal-100 where empno=7369;

1 row updated.

SQL> commit;

Commit complete.

SQL> select empno, sal, versions_starttime,versions_xid

2 from emp

3 versions between timestamp sysdate-1 and sysdate

4 where empno=7369;

EMPNO SAL VERSIONS_STARTTIME VERSIONS_XID

---------- ---------- --------------------------------------------------------------------------- --

7369 5900 11-DEC-08 16.05.32 0014001300002A74

7369 5800 11-DEC-08 16.03.32 000D002200012EB1

7369 5800

请注意，您可以走多远受UNDO_RETENTION参数的限制，通常为几小时而不是几天。

2021-03-23