hi ,
i updated data yesterday 10-aug-2015 at night twice , and now i want to revert to the data before first update before this date which was 10-aug-2015 at daylight .
i am trying to use Flashback Query (SELECT ... AS OF) , but it does not get the data , it retrieves the data status now .
SELECT tests_entry_lines.result , tests_entry_lines.result2 , tests.test_name
FROM tests_entry_lines, tests AS OF TIMESTAMP
TO_TIMESTAMP('2015-08-09 09:30:00', 'YYYY-MM-DD HH:MI:SS')
WHERE tests_entry_lines.test_code = tests.test_code
and tests_entry_lines.REG_KEY = 15000000016398
AND tests_entry_lines.TEST_STATUS = 5
AND tests_entry_lines.RESULT IS NULL;
. ?