From my text. Steve O'hearn Ora-1z0-047 textbook. Chapter 15 last couple of pages
You can combine the AS OF clause and the VERSIONS BETWEEN clause in a single SELECT statement.
For example:
SELECT CHAT_ID, VERSIONS_STARTSCN, VERSIONS_ENDSCN, VERSIONS_OPERATION
FROM CHAT
VERSIONS BETWEEN TIMESTAMP MINVALUE
AND MAXVALUE
AS OF TIMESTAMP SYSTIMESTAMP - INTERVAL '0 00:15:00' DAY TO SECOND
ORDER BY CHAT_ID, VERSIONS_OPERATION DESC;
Note that the VERSIONS BETWEEN clause precedes the AS OF clause; this
is required. When combined, the VERSIONS BETWEEN values are determined
AS OF the time specified by the AS OF clause.;;;
so from the above query is the versions between being operated on min and max values from the prespective of the AS OF clause --
in other worths in this case the highest possible maxvalue can be is 15 minutes ago?
SELECT CHAT_ID, VERSIONS_STARTSCN, VERSIONS_ENDSCN, VERSIONS_OPERATION
FROM CHAT
VERSIONS BETWEEN TIMESTAMP MINVALUE
AND MAXVALUE
AS OF TIMESTAMP SYSTIMESTAMP - INTERVAL '0 00:15:00' DAY TO SECOND
ORDER BY CHAT_ID, VERSIONS_OPERATION DESC;
yes I have been playing with version flashbacks all night and I will try it myself. Just wouldn't hurt to have some advice.
Thanks much.