--10g中闪回版本查询，查询对表的更改
SELECT VERSIONS_STARTTIME,
VERSIONS_ENDTIME,
VERSIONS_XID,
VERSIONS_OPERATION,
EMAIL
FROM TEMP_LING_CPNAME VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE
ORDER BY VERSIONS_STARTTIME;
SELECT * FROM FLASHBACK_TRANSACTION_QUERY WHERE XID = '01002F00567C0000';
SELECT VERSIONS_STARTTIME,
VERSIONS_ENDTIME,
VERSIONS_XID,
VERSIONS_OPERATION,
FROM TEMP_LING_CPNAME VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE
ORDER BY VERSIONS_STARTTIME;
SELECT * FROM FLASHBACK_TRANSACTION_QUERY WHERE XID = '01002F00567C0000';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24387280/viewspace-681790/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORACLE时间处理大全
请登录后发表评论
登录
全部评论
