code_junkie

adding oracle's timestamp to query results

Nov 12th, 2011
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. SQL> select empno, sal, versions_starttime,versions_xid
  2. 2 from emp
  3. 3 versions between timestamp sysdate-1 and sysdate
  4. 4 where empno=7369;
  5.  
  6. EMPNO SAL VERSIONS_STARTTIME VERSIONS_XID
  7. ---------- ---------- --------------------------------------------------------------------------- --
  8. 7369 5900 11-DEC-08 16.05.32 0014001300002A74
  9. 7369 5800 11-DEC-08 16.03.32 000D002200012EB1
  10. 7369 5800
Add Comment
Please, Sign In to add comment