Version Query Pseudocolumns

The version query pseudocolumns are only valid for flashback version query which are discussed on Flashback Version Query.

The available version query pseudocolumns are,

1)VERSIONS_STARTTIME: This pseudocolumn returns the timestamp of the first version of the rows returned by the query.

2)VERSIONS_STARTSCN: This pseudocolumn returns the SCN of the first version of the rows returned by the query.

3)VERSIONS_ENDTIME: This pseudocolumn returns the timestamp of the last version of the rows returned by the query.

4)VERSIONS_ENDSCN: This pseudocolumn returns the SCN of the last version of the rows returned by the query.

5)VERSIONS_XID: This pseudocolumn returns the transaction ID of the transaction that created that row version.

6)VERSIONS_OPERATION: This pseudocolumn returns a single character representing the operation that caused that row version.

It can have I-For Insert Operation.
U-For Update Operation.
D-For Delete Operation.