Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment