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).

  See Also:

  flashback_query_clause for more information on version queries