是的，像这样：
SQL> select sal from emp where empno=7369; SAL---------- 5800SQL> 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参数的限制，通常为几小时而不是几天。
