flashback versions query中常用的伪列

flashback versions query中出现的伪列比较多，不容易记住，放在这里备查。[@more@]

scn：

select versions_operation,versions_startscn,versions_endscn,
versions_starttime,versions_endtime,versions_xid,id,name
from t versions between scn minvalue and maxvalue

--=========================================

timestamp：

select versions_operation,versions_startscn,versions_endscn,
versions_starttime,versions_endtime,versions_xid,id,name
from t versions between timestamp minvalue and maxvalue

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1059307/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1059307/