martes, 31 de marzo de 2020

FLASHBACK VERSIONS BETWEEN

select * from hr.prueba;

update hr.prueba set salary=25000 where employee_id=100;
commit;

select salary from hr.prueba
as of timestamp (systimestamp - interval '1' MINUTE)
where employee_id=100;

select versions_starttime, versions_endtime, employee_id,salary from hr.prueba
versions between scn minvalue and maxvalue
where employee_id=100;

No hay comentarios: