【SQL开源代码栏目提醒】:本文主要为网学会员提供17.9.4.sql,希望对需要17.9.4.sql网友有所帮助,学习一下!
--使用带有VERSIONS BETWEEN子句的SELECT语句来指定Flashback Verison Query
col versions_startscn format 99999999
SELECT versions_startscn, versions_starttime,
versions_endscn, versions_endtime,
versions_xid, versions_operation,
empno,empname, salary
FROM emp1
VERSIONS BETWEEN TIMESTAMP
TO_TIMESTAMP('2008-07-06 10:22:00', 'YYYY-MM-DD HH24:MI:SS')
AND TO_TIMESTAMP('2008-07-06 10:30:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE empno= 7369;