Database Reference
In-Depth Information
Figure 13.7
The
CONNECT
_BY_ ISCYCLE
Pseudocolumn.
Figure 13.8
The
CONNECT
_BY_ ISLEAF
Pseudocolumn.
10
. A flashback
versions query can be used to return more than one version of a single row
both before and after a change.
g
additionally allows what are called
flashback versions queries
Note:
Flashback queries require automated undo. Manual rollbacks, now
desupported, will not support flashback queries.
13.3.1
Flashback Query Syntax
Figure 13.9 shows the syntax for flashback queries.
Note:
The DBMS_FLASHBACK package can be used to create flashback
queries at the session level.
 
Search WWH ::




Custom Search