| Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
| Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
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).
