Table 12-1 Oracle Flashback Version Query Row Data Pseudocolumns
Pseudocolumn Name
Description
VERSIONS_STARTSCN
VERSIONS_STARTTIME
Starting System Change Number (SCN) or TIMESTAMP when the row version was created. This pseudocolumn identifies the time when the data first had the values reflected in the row version. Use this pseudocolumn to identify the past target time for Oracle Flashback Table or Oracle Flashback Query.
If this pseudocolumn is NULL, then the row version was created before start.
VERSIONS_ENDSCN
VERSIONS_ENDTIME
SCN or TIMESTAMP when the row version expired.
If this pseudocolumn is NULL, then either the row version was current at the time of the query or the row corresponds to a DELETE operation.
VERSIONS_XID
Identifier of the transaction that created the row version.
VERSIONS_OPERATION
Operation performed by the transaction: I for insertion, D for deletion, or U for update. The version is that of the row that was inserted, deleted, or updated; that is, the row after anINSERT operation, the row before a DELETE operation, or the row affected by an UPDATEoperation.
For user updates of an index key, Oracle Flashback Version Query might treat an UPDATEoperation as two operations, DELETE plus INSERT, represented as two version rows with a Dfollowed by an IVERSIONS_OPERATION.
The results table rows are in descending chronological order. The third row corresponds to the version of the row in the table emp that was inserted in the table when the table was created. T
he second row corresponds to the row in emp that the erroneous transaction deleted. The first row corresponds to the version of the row in emp that was reinserted with a new employee name.