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);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12402/viewspace-972643/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12402/viewspace-972643/