| 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 |