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).
See Also:
flashback_query_clause for more information on version queries