Flashback Query

select count(*) from HR_CA06_ACHIEVEMENT as of timestamp (systimestamp - interval '5' hour) ;

SELECT * FROM EMPLOYEE AS OF TIMESTAMP 
   TO_TIMESTAMP('2003-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')
   WHERE name = 'JOHN';