JULIA@aux Dec 25 2013 22:42:46> /
NAME PHONE
------------------------------ ---------------
julia1 18575531877
julia 18575531878
julia2 18575531879
JULIA@aux Dec 25 2013 22:40:32> SELECT versions_startscn, versions_starttime,versions_endscn, versions_endtime,versions_xid, versions_operation,name, phone FROM juliatest
2 VERSIONS BETWEEN TIMESTAMP
3 TO_TIMESTAMP('2013-12-25 01:11:00', 'YYYY-MM-DD HH24:MI:SS')
4 AND TO_TIMESTAMP('2013-12-25 22:40:00', 'YYYY-MM-DD HH24:MI:SS')
5 WHERE name = 'julia';
VERSIONS_STARTSCN VERSIONS_STARTTIME VERSIONS_ENDSCN VERSIONS_ENDTIME VERSIONS_XID V NAME PHONE
----------------- ------------------------------ --------------- ---------------------------------------- ---------------- - ------------------------------ ---------------
32743176 25-DEC-13 10.38.29 PM 0A00140038400000 I julia 18575531878
32743136 25-DEC-13 10.37.28 PM 03001F0010410000 D julia 18575531876
32743136 25-DEC-13 10.37.28 PM 03001F0010410000 D julia 18575531876
32680098 25-DEC-13 01.37.34 AM 32743136 25-DEC-13 10.37.28 PM 02000800CA400000 U julia 18575531876
32680098 25-DEC-13 01.37.34 AM 32743136 25-DEC-13 10.37.28 PM 02000800CA400000 U julia 18575531876
Pseudocolumn Name | Description |
---|---|
Starting System Change Number (SCN) or If this pseudocolumn is | |
SCN or If this pseudocolumn is | |
Identifier of the transaction that created the row version. | |
Operation performed by the transaction: For user updates of an index key, Oracle Flashback Version Query might treat an |