Adding oracle's timestamp to query results?

Yes, in fact the answer to your previous question shows how.

Yes, in fact 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 a VERSIONS_ENDTIME pseudo-column.

Between them VERSIONS_STARTTIME and VERSIONS_ENDTIME bracket the period of time during which the change was made.

Except that I got an "OCI invalid handle" error in toad :-( – Zsolt Botykai Dec 12 '08 at 13:06 That would be a Toad problem. Try SQL Plus. – Tony Andrews Dec 12 '08 at 13:08 You are right, thanks again.

– Zsolt Botykai Dec 12 '08 at 13:36.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions