| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
| 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 |
|
 Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
HTML