===========================================================
Oracle10g的Flashback version Query
===========================================================
作者: xsb(http://xsb.itpub.net)
发表于:2007.09.27 11:52
分类: Oracle
出处：http://xsb.itpub.net/post/419/400066
---------------------------------------------------------------
发表于:2007.09.27 11:52
分类: Oracle
出处：http://xsb.itpub.net/post/419/400066
---------------------------------------------------------------
http://www.eygle.com/archives/2005/03/oracle10gaeflas.html
SELECT versions_starttime, versions_endtime, versions_xid, versions_operation, a.*
FROM system_config versions BETWEEN TIMESTAMP minvalue AND maxvalue a
WHERE config_key = '***';
SELECT versions_starttime, versions_endtime, versions_xid, versions_operation, a.*
FROM system_config versions BETWEEN TIMESTAMP SYSDATE-10/24/60 AND SYSDATE a
WHERE config_key = '***'
ORDER BY nvl(versions_starttime,SYSDATE-999);
re: Oracle10g的Flashback version Query