oracle闪回学习三

闪回版本查询
SQL> select salary from hr.employees where employee_id = 200;


    SALARY
----------
      4400
SQL> update hr.employees set salary = 11111 where employee_id = 200;


1 row updated.


SQL> commit;


Commit complete.


SQL> update hr.employees set salary = 22222 where employee_id = 200;


1 row updated.


SQL> commit;


Commit complete.


SQL> update hr.employees set salary = 33333 where employee_id = 200;


1 row updated.


SQL> commit;


Commit complete.


SQL> update hr.employees set salary = 44444 where employee_id = 200;


1 row updated.


SQL> commit;


Commit complete.


SQL> select employee_id,salary
from hr.employees
versions between timestamp (systimestamp - interval '10' minute)
and maxvalue
where employee_id = 200;


EMPLOYEE_ID SALARY
----------- ----------
200 44444
200 33333
200 22222
200 11111
200  4400

说明4个事务对salary进行了修改。