| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
DBA_COMPARISON_SCAN_VALUES displays information about the values for all comparison scans in the database.
USER_COMPARISON_SCAN_VALUES displays information about the values for the comparison scans owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
OWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the comparison scan | 
COMPARISON_SCAN | 
VARCHAR2(30) | 
NOT NULL | 
Name of the comparison scan | 
SCAN_ID | 
NUMBER | 
NOT NULL | 
Scan ID | 
COLUMN_POSITION | 
NUMBER | 
NOT NULL | 
Column position, as in DBA_COMPARISON_COLUMNS | 
MIN_VALUE | 
VARCHAR2(4000) | 
Minimum value of the scan | |
MAX_VALUE | 
VARCHAR2(4000) | 
Maximum value of the scan | |
LAST_UPDATE_TIME | 
TIMESTAMP(6) | 
Time that this row was last updated |