Flashback query as of timestamp - Oracle Database Script. SELECT * FROM AODBA.EMP AS OF TIMESTAMP TO_TIMESTAMP('2017-01-07 10:00:00', 'YYYY-MM-DD HH:MI:SS'); SELECT * FROM AODBA.EMP AS OF TIMESTAMP SYSDATE -1/24;
SELECT * FROM AODBA.EMP AS OF TIMESTAMP TO_TIMESTAMP('2017-01-07 10:00:00', 'YYYY-MM-DD HH:MI:SS'); SELECT * FROM AODBA.EMP AS OF TIMESTAMP SYSDATE -1/24;