Database Reference
In-Depth Information
The pseudocolumns available under Flashback Version Query
are as follows.
VERSIONS_STARTSCN
This field provides the starting System Change Number (SCN)
when the row was first created inside the table. If there is NULL
value in this field it means that row version was created before
the lower SCN bound as defined in the BETWEEN … AND …
clause.
VERSIONS_STARTTIME
This field provides the starting TIMESTAMP when the row was
first created inside the table. If there is NULL value in this field
it means that row version was created before the lower time
bound as defined in the BETWEEN … AND … clause.
VERSIONS_ENDSCN
This field provides the ending System Change Number (SCN)
when the row version expired. If there is a NULL value in this
field, it means either the row is still current or it corresponds to a
DELETE operation.
VERSIONS_ENDTIME
This field provides the ending TIMESTAMP when the row
version expired. If there is a NULL value in this field, it means
either the row is still current or it corresponds to a DELETE
operation.
VERSIONS_XID
Each row version has been assigned an identifier,
VERSIONS_XID field provides this information.
VERSIONS_OPERATION
This field provides the nature of operation happened that resulted
in the row version. If it contains I, it means the version of the
row created because of INSERT operation. Similarly, U
represents UPDATE and D as DELETE operation.
Search WWH ::
Custom Search