Oracle10g的Flashback version Query

xsb發表於2007-09-27

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);

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12402/viewspace-972643/,如需轉載,請註明出處,否則將追究法律責任。

相關文章