Previous Data Query in Oracle

Data of Five minutes past:

select * from employees as of timestamp(sysdate-interval '5' minute)

insert into emplyess
select * from employees as of timestamp(sysdate-interval '5' minute)

 

 

select * from AC_VOUCHERDTL as of timestamp sysdate-interval '30' minute
minus
select * from AC_VOUCHERDTL

FLASHBACK TABLE employees TO TIMESTAMP
TO_TIMESTAMP('2025-06-29 14:00:00', 'YYYY-MM-DD HH24:MI:SS');