Version Query Pseudocolumns
The version query pseudocolumns are valid only in Oracle Flashback Version Query, which is a form of Oracle Flashback Query. The version query pseudocolumns are:
-
VERSIONS_STARTTIME: Returns the timestamp of the first version of the rows returned by the query.
-
VERSIONS_STARTSCN: Returns the SCN of the first version of the rows returned by the query.
-
VERSIONS_ENDTIME: Returns the timestamp of the last version of the rows returned by the query.
-
VERSIONS_ENDSCN: Returns the SCN of the last version of the rows returned by the query.
-
VERSIONS_XID: For each version of each row, returns the transaction ID (a RAW number) of the transaction that created that row version.
-
VERSIONS_OPERATION: For each version of each row, returns a single character representing the operation that caused that row version. The values returned are I (for an insert operation), U (for an update operation) or D (for a delete operation).
