📋Steps in this guide1/1

Flashback query as of timestamp

SELECT * FROM DBACLASS.EMP AS OF TIMESTAMP TO_TIMESTAMP('2017-01-07 10:00:00', 'YYYY-MM-DD HH:MI:SS');

oracle configurationintermediate

by OracleDba

20 views

Flashback query as of timestamp

Code/Command (click line numbers to comment):

1
2
3

SELECT * FROM DBACLASS.EMP AS OF TIMESTAMP
TO_TIMESTAMP('2017-01-07 10:00:00', 'YYYY-MM-DD HH:MI:SS');
SELECT * FROM DBACLASS.EMP AS OF TIMESTAMP SYSDATE -1/24;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!