[20151103]versions伪列.txt

[20151103]versions伪列.txt

--经常忘记做一个记录.

SELECT versions_starttime, versions_endtime, versions_xid, versions_operation,
       versions_startscn, versions_endscn, empno, ename, job, mgr, hiredate,
       sal, comm, deptno
  FROM emp
       VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE
       where empno=7369
--order by VERSIONS_STARTTIME; 

SELECT * FROM emp
  VERSIONS BETWEEN TIMESTAMP
    SYSTIMESTAMP - INTERVAL '30' MINUTE AND
    SYSTIMESTAMP - INTERVAL '1' MINUTE
    WHERE empno=7369;

VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;

select * from flashback_transaction_query  where xid=hextoraw(:yyy) ;

--一共有这些字段:
versions_starttime
versions_endtime
versions_xid
versions_operation,
versions_startscn
versions_endscn