[Home] [Help] [Dependency Information]
Object Name: | USER_COMPARISON_SCAN_VALUES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about a comparison scan's values
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPARISON_NAME | VARCHAR2 | (128) | Yes | Name of comparison |
SCAN_ID | NUMBER | Yes | Scan id of scan | |
COLUMN_POSITION | NUMBER | Yes | Column position as in user_comparison_columns | |
MIN_VALUE | VARCHAR2 | (4000) | Minimum value of scan | |
MAX_VALUE | VARCHAR2 | (4000) | Maximum value of scan | |
LAST_UPDATE_TIME | TIMESTAMP(6) | (11) | The time that this row was updated |
Cut, paste (and edit) the following text to query this object:
SELECT COMPARISON_NAME
, SCAN_ID
, COLUMN_POSITION
, MIN_VALUE
, MAX_VALUE
, LAST_UPDATE_TIME
FROM SYS.USER_COMPARISON_SCAN_VALUES;
|
|
|