Clever Geek Handbook

Add oracle timestamp to query results

yesterday you taught me to query the history of records within a time range here .

What else I need is to add the oracle (history) timestamp to the results as a column. Is it possible?

Thanks in advance.

+1


source to share


1 answer


Yes, actually the answer to your previous question shows how:

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


There is also the pseudo-column VERSIONS_ENDTIME. In between VERSIONS_STARTTIME and VERSIONS_ENDTIME, copy the time period during which the change was made.

+2


source






More articles:


All Articles